Is there any way in which I can count a field once in a query even though it
repeat quite a few times.
SELECT TimeCard.DateEntered, Sum(TimeCard.OT_HRS) AS SumOfOT_HRS,
Sum(TimeCard.PD_HRS) AS SumOfPD_HRS, Count(DriverInfo.DRIVER_ID) AS

I have a parts inventory database. In the database I have a query that
searches by part description. When I run the query a window pop ups and
requests to input a part description. If I put in the complete and exact name
of the part, I get the total number of that particular part ...

Access XP.
I have a table with a text field, which can have letter values A, B, C, or
D, or it can be null.
A query on that table, with criterion for that field set to [<>"C"] excludes

I have some data (prices) where I want ever value to go to 3 decimals
regardless of value.  If price is 8 I want it to be 8.000, if it is 12.15 I
want 12.150
Don't want currency sign.  I have tried playing with format, multiplying by

How can I create consecutively numbered invoices?

I am importing an xml document into Access 2003. The only problem is the xml
document (which is actually an Adobe Premiere project, if anyone is familiar
with those) uses naming conventions for fields that Access doesn't like -
e.g. "AudioSettings.Compile".

I have a database of company names, and i need to filter out certain names
that are franchises etc, such as Wendy's and Kroger.  I would like the filter
to be a list of names that could be 10 or 12 entries long, but I cannot use
NOT LIKE on more than one entry apparently.  is ...

i use an autoexec macro to run several queries on a db.(db opens through a
scheduled batch file)
the queries use linked oracle tables (through ODBC's) to 12 different
databases in 12 different servers

Crosstab is missing data from underlying table
while NO WHERE/HAVING clauses exist!
(Issue tested on Access97 SR1 & SR2):
this is WRONG results (jpeg shot):

I have this expression to determine which commission rate to use in an append
qry.  
FinalCommRate: IIf(Not
IsNull([dbo_ar_cstmrmst]![commission_plan]),([dbo_op_commplandt_1]![commission_rate]/100),([dbo_op_commplandt]![commission_rate]/100))

I have a form with a option group with 5 options.
I want to filter records with a priority field in this query.
The field have the value of 1,2,3,4 or 5.
I have tried IIF's VBA , but I cant figure this out !

I've made a query that should use a boolean value as criteria.
The query is in Access, the data on SQL Server.
When the criteria is YES (or True), the query brings the correct result.
When the criteria is NO (or False), the query brings no results at all!?

Goodday,
I have a query containing the following fields:
Categorie
CountofCategorie (Totals per Categorie)

We are developing a Property inspection query.  We would
like to retrive all Property with Inspection date is NULL.
Property and Inspection are two different tables.  I know
how to extract all information about property that has

I have a query that creates a field which gives the person's next birthday
based upon their birthdate.  It is:
SELECT tblContacts.conFName1, tblContacts.conLName1,
DateSerial(Year(Date())-(DateSerial(Year(Date()),Month([conBirthday1]),Day([conBirthday1]))<Date()) ...