I have a crosstab query with a sum of the values as a row heading called
TOTAL. In other words if my columns are 1 through  12 then the 'total' field
reports the sum of 1 - 12 for each record. So far no  problems.
Th bit I am having trouble with is some of the totals equal zero ...

I am trying to create a query where the user will require to enter the from
and to date and also the query to create a sum of the amount field.
When I apply the sum to the field required I get 0 amount in my total field
that I apply the sum to.

 I know this sounds troubling, but bear with me... The data is not
particularly important at the moment.  Anyway, I have a field with first and
last names (yea, both in one field).  Various spellings, some include
Mr./Mrs, some include PhD, etc.  I am trying to do a LIKE ...

Access 2003...Windows XP
Wantng to establish a Filter by Form, I have built a query string called:
'strWhere'
This was applied using:

I have a table of members all of whom have a unique membership number.  I
need a query to pull records on several members at once by the membership
number. i.e. a criteria like (1131, 1326, 3815...)  I would need to enter
multiple various (not random) mem numbers on a form, and ...

I have a form on which the user can choose an existing table or query. The
user then identifies filter criteria using a provided field list, operators
(<,>, =, etc.) and values to, in essence, specify their own filter by form.
Ultimately, I want to export the results to an Excel ...

Somebody surely has run into this - I have a query that runs a report for
open orders based on current date, and identifies Wk/Mo/Qtr.  I need to
separate out the values for wk/mo/qtr into separate queries and subtotal,
then write a make-table query that will put subtotal values ...

Using Access 2003.  Have a table with hospital admissions.  Am trying to
retrieve records where a person has an admission within 30 days of another
admission.  Each record has a unique identifier, each member has a member
number, and there is an admitdate field.  I've tried a ...

I need to find suspected duplicates in a query.  I started with the find
duplicates query and made the following modifications:
In (SELECT (Left$([Application], 20))   FROM [Quest_Application_Count] As
Tmp GROUP BY [Application] HAVING Count(*)>1 )

I need a query and a form that will allow users to access specific multiple
records.  In this case, membership numbers from a table i.e. 2131, 1132,
4327...   I understand the IN (2131, 1132...) criteria function, but how do I
incorporate that into a form that asks for those ...

Access 2000
I want to know if it is possible to reference the previous value in a field
when designing a query.
Query A:

Hi, I have a table I need to update.I plane on importing my spreadsheet to
the table. If I have a matching record, what is the best way to put the
vewest data into my table?
Hope I explained this ok

I have a query that searches for previous entries in a employee table and
prints a report if it finds an existing record, i.e. there is an employee by
the name "Smith".  How can I get the query to return a message box that says
"No record found" if there are no records, that ...

I've been wracking my head all day with this one.
A file gets assigned to a agent here and over time it gets passed around.
The date the file gets assigned to the agent is recorded. So I have an
invoice table with an agent table and an agentinvoice table in between to

I hope this is the right forum for this question.   I am working in an Access
database and need to import data from another database, and that data is from
the result of running a stored query, rather than a table.  That data, in
turn, is being used to populate a table in the ...