I want to set multiple parameter queries, and allow the user to enter a
parameter for each of them or to select all if they don't want to limit
that field.  What does the user type in if they want to see all in that
field?  Or if they leave it blank, is there a way to code that ...

I am running a query to select all payment and payment reversal records for a
corporation based on company name. When I do this I lose seven records
because they match similar records. I want these records included in my
query. What am I doing wrong to not see these records in my ...

I have a main employee table that used to contain about 50 extra fields
pertaining to employees skills and experience. In an effort to normalize
data. I have created 2 extra tables that are linked one to many (enforce
referencial integrity) to the employee record via a foreign ...

This is a question for Access 2000.
I need to search a large table to find specific records (the criteria will
be a date) then once these records are identified I need to update a field in
a related record within the same table (I will be able to identify the

have a True/False field in a query that we want to export to a text file but
when we do the true/false comes out as 1/0
Is there any way I can get the report to export out the words
"True" or "False"

I have built a query, that sums a field which is based on a combo box. As it
only sums the combo boxes that are checked it gives a -1 for every input. For
each country i now have figures of -20, -63, -8 for each country.
How do I turn these into positives?

I currently have a query which has sums based on whether a quote has been
sent, in action, or rejected. I have built totals of these with percentages
based on the overall number of quotes being dealt with.
However, I need to add data from a different table with the amount of money ...

I was wondering if you guys would know the best way to pursue the
following problem.  I have two tables, one with the unique items and
another with all the changes that occurred to the item.  For example:
Table1

HELP!!! I have a query with a date field, TransDate.  I want to pull up all
records where the month section of TransDate is one calendar month before
today's date.  For instance:  If today is 11/10/2006 then it would pull up
all records where TransDate was between 01/09/2006 and ...

I am counting fields to track and reward employee productivity.  These are
date type fields. The associate enters a date for up to three different tasks
they provide each record.  They get credit for each date and can have
anywhere from 0 to 3 entries.

I have a recipie database with many tables and I am trying to make a new
table based on a query. In this table I want only 1 row per ingredient.
this is a simplified eksample
Ingredient table

I am attempting to produce two sub-totals. One is for the amount of money
paid in to buy extended warranties, and the other is the amount of money paid
out to cover warranty repairs. My SQL statement is below:
SELECT DISTINCTROW tblWarranties.WarrantyDateOfPurchase,

If I have a feild that has the number 54200 in it how can I trim off the 00
so I end up with 542?  When I try the the left function I get the results I
want but it converts the data type from a number to a text feild.  I need to
keep this feild a number data type.  Any ...

I have created a crosstab query and I would like to use the information in a
report.  I can't figure out how to get the total number of Lost for Jan in
my report.  I need the same thing for Won.  Below is an example of my
crosstab query:

I have a database with linked tables and the following query:
SELECT
tmp_chgclosed.CaseId,
sitesla.SLAlevel,