How refer to column of listbox in a query?
My SQL:
SELECT ID, Category
FROM tblCategory

How can I query [Comments] and return all of the records that contain
"retired" or "Retired"?
Thanks!

I'm slowly learning SQL and have been setting myself small
tasks/problems to solve as a way of doing so.
One of these was to count the unique values in one field.  My learning
told me this would be a simple case of:

I have a query containing 3 sub (grouped) queries and 1 Customers table. The
subs are: Invoices, Payments, Credits. From Customers, there are 1209 records
of field "BF Total". Fields from Invoices indicate 595 records, Payments 30
records, Credits 20 records. When I connect a ...

I have a macro that calls a crosstab query, that is based on a select query.
The select query references a form for data input.
When I click the form's command button to run the macro, I get this error:
The Microsoft Jet Database does not recognize Forms!frmMainKPI!txtSOStartDate ...

I have to create a "Certificate" report which will have a unique numeric
reference for each "Certificate" generated.
I have created a select query that pulls the various pieces of data needed
to form the "Certificate" from the appropriate tables. The main points from

Dale, thanks for taking the time. Whether I get a solution or not, I think it
is damn kind of you. Below is the SQL of the troubling run that gives
"Invalid use of Null":-
SELECT [Invoices Grouped].[Invoice No], [Invoices Grouped].CustomerID,

Hi, All
i have a query (all credits to Chis2)
TRANSFORM Nz(COUNT(TempTicks.Tick),0) AS CountOfTick
SELECT TempTicks.Badge

Is there a way to replace all null values by zeroes in a table?
I need to find all null values in all fields for several tables, the UPDATE
query only allows me to replace one field at a time, and I have hundreds of
fields to search and replace.

I am trying to put in an calculated field in my report.  I have a field
called "qualified" and in the field I would like it to total the number of
"yes" fields.  I have tried =iff([qualified] = "yes",count"yes") but that
doesn't work.  I think I am close.  Does anyone have any ...

I need to use comparison function of "Least" and "Greatest" in Oracle.
For example, Greatest (field1, field2, field3 ....) and if the value of
field2 is the greatest, then return the value of field2.
Could someone tell me the ways of implementing least and greatest functions

I enter Invoice Summary and Invoice Detail information via a Form/
Subform .  The Invoice Summary contains only Customer Number, Date,
and Invoice Number.  The Quantity, Unit Price and Tax information is
stored in the Invoice Detail.

I have a query where all services are captured; I would like to be able to
have the total time calculated.
The field I want to add up is "total time."  Im stuck and what Ive been
getting is the total time per line or record which is the same. Im looking to

Is there a way to set a time field default (in table) to Now() and have it
round to the nearest  hour?

I thought this was going to be an easy one...I need a query that provides a
count of the number of requests taken per hour and the total number of
requests for the day.
Requests between 7:00 AM and 8:00 AM = 50