A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Post New Thread
Threads in Forum : Running & Setting Up Queries Forum Tools Search this Forum Feed Icon
  Thread / Thread Starter Last Post Reverse Sort Order Replies Views
Running Total in Access 2003 by Jasper Recto
I have a query that has 4 columns Date, Qty, UnitPrice and Amount. The amount is a formula that multiplies Qty x UnitPrice. I would like a 5th column that...
July 9th, 2008 03:49 PM
by Wayne-I-M Go to last post
4 423
append to a linked excel table by Octet32
I have a excel spreadsheet linked to an access database when I try to append a query to the excel table everything seem to work fine but when I look at the...
July 9th, 2008 03:30 PM
by Klatuu Go to last post
7 188
Problem with fConcatChild by dalecorey1 via AccessMonster.com
Hi, I was hoping fConcatChild would be the answer to my concatenation problem I am receiving really strange results. Here's my 1:M data (Directive-Number is...
July 9th, 2008 03:25 PM
by Amy Blankenship Go to last post
1 139
IIF Statement - HELP! by susan
I need help with an IIF statement for the following: If StdPrice = 0, give me "rebill" If Part# ends with "-OSP",give me "outside processing" I got the first...
July 9th, 2008 02:42 PM
by susan Go to last post
2 123
Compare dates by nisreenkh
1- How can I compare various dates in Access query. For example, I have a "purchase date", "sold date", with which i want to compare with a "start date" and...
July 9th, 2008 02:31 PM
by Michel Walsh Go to last post
1 108
I have a table containing the following fields Code Car type Ownername Ownership% 002 Toyota Pickup John 50 002 ...
July 9th, 2008 02:28 PM
by Michel Walsh Go to last post
2 143
Percentile Formula for Access by ZombieGeoff
I am trying to create a query that will calculate the 25th, 50th, and 75th percentile of salaries within specific job codes. I currently have a table of all...
July 9th, 2008 02:04 PM
by Michel Walsh Go to last post
1 129
need to calculate the quartile in ms access by makandriaco
how can I show the quartile (25 percentile) or (75 percentile) of a data
July 9th, 2008 01:22 PM
by Bob Barrows [MVP] Go to last post
1 221
splitting fields of ids and title. by Database User
Hello, I'm wondering if anyone can help - i have an id field that i would like to split into a few fields wherever there is a dash i want it to be a new...
July 9th, 2008 01:17 PM
by Bob Barrows [MVP] Go to last post
1 91
autonumber - function by [email protected]
Hi, I will like the function. Is there a way to make it a default as 0 in the table: tblHighNum. Public Function isIncrement(ByVal var As Variant) As...
July 9th, 2008 01:09 PM
by Bob Barrows [MVP] Go to last post
1 137
Table not in List to Append to by MIG
I must be missing something really obvious, but I want to append some rows to a table I've created, but when I change my query type to Append, the list of...
July 9th, 2008 12:15 PM
by MIG Go to last post
3 134
Copy records without dupliacates by cmweb via AccessMonster.com
Hello I need a query to copy records from a table to another table without duplicates. Many thanks in advance and your help is most appreciated. Carlos --...
July 9th, 2008 07:02 AM
by Allen Browne Go to last post
1 117
Months are different from days by Kevbro7189
I have a query that looks at a table with a list of dates, and data. I want to use the query to pull out everything with in the past 3 months (not days like...
July 9th, 2008 03:27 AM
by Kevbro7189 Go to last post
3 160
left "_" & "-" by Gary F Shelton
Here is some of my data that I want to unconcatonate... Need some help with doing this as you can see the data length changes with each change of...
July 9th, 2008 03:23 AM
by Gary F Shelton Go to last post
5 145
Update Query Question by NeonSky via AccessMonster.com
Good Afternoon, Wow I am surprised I am having so much trouble with something that is so simple...perhaps you can tell me if what I am trying to do is even...
July 9th, 2008 12:41 AM
by Douglas J. Steele Go to last post
3 132
Unformat Phone Number Field by Brad[_6_]
All, I have a database table that has a field Fax_Numbers that have fax numbers saved in the format: (333) 444-5555. I wish to use these numbers in a query...
July 9th, 2008 12:38 AM
by Brad[_6_] Go to last post
2 172
Can you put an IF statement in a query expression? by Jimbo213
How can I create this expression in a query FITOK: =IIF(OR( =75,=0),"OK","No") Thanks for your reply & assistance. Jimbo213
July 8th, 2008 11:37 PM
by Jimbo213 Go to last post
2 171
User Select Top Value Percentage by DaveAP
Is there a way to select a different top value or percentage of the queries results from a form? We have four different types of auditing based upon the...
July 8th, 2008 09:00 PM
by DaveAP Go to last post
8 205
Formula for quering a range of numbers by NervousFred
I have a database that has a field of numbers in it used to identify aircraft. From this I only need a certain set of aircraft. The aircraft are in the...
July 8th, 2008 08:56 PM
by NervousFred Go to last post
2 112
dates in queries by Debbie S.[_2_]
Hi, I have a database with titles of articles and a log form. The titles and the log form are in two different but related tables. The log form has four...
July 8th, 2008 08:23 PM
by bhicks11 via AccessMonster.com Go to last post
2 122
Post New Thread

Display Options
Showing threads 10021 to 10040 of 43289
Sorted By Sort Order
From The
Forum Tools Search this Forum
Search this Forum :

Advanced Search

New posts New posts More than 15 replies or 150 views Hot thread with new posts
No new posts No new posts More than 15 replies or 150 views Hot thread with no new posts
Closed Thread Thread is closed  
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

All times are GMT +1. The time now is 07:45 AM.

Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 OfficeFrustration.
The comments are property of their posters.