i created an outer join in access 2003.  The results work fine, and I get the
expected null fields.  I can format the resulting numbers  in the query and
in a report as standsrd with two decimal places.  I then used the nz function
to change the nulls to zeros, which works fine ...

I am puzzled by this syntax error.  I am using the same code over and over
again (with minor modifications to field names) and this error seems to pop
up.  
Below is the code that is causing the problem, do any of you see what is

Hi, I have two tables, where the child table has two primary keys to link it
to the parent table. I'm trying to create an unmatched query where it will
find any records on the parent table that don't have corresponding rows on
the child table, but I'm stuck. Does anyone have some ...

I am creating a report base on the filtered results from the query. Sometimes
there is no results after filtering. The query is total blank. As my report
is unable to total once there is a blank. How do I replace the query blank
result with "0"?

I am desperate I don't know vb, yet I want to enter a count function to count
records in a table or query.  Any help is greatly appreciated.  I need as
soon as possible.

I'm trying to create a parameter that allows you to enter two values. For
example, in my query I created a parameter to enter the brand so that the
query only pulls information for that one brand. I want to create a query
where you can select two brands so the report pulls up ...

I am using MS Access 2007.  my problem is that I have table with over
177,000 records and for some reason in data transfers one of my fields
measurement_time has dropped a leading zerro.  i.e 08:40 now is 8:41.
the problem comes starts with that I have exact duplicate of records

I have two tables, a product master file and a price list which is a subset
of the product master file.  I need to find all records that are in the
product master file but not in the price list.  The part number(MPN) is key
in both tables.  I tried a query where MPN is "not like ...

I have a table with a Chronological Age column, defined as Single, fixed,
with auto decimal places.  I have an update query that does a DateDiff
function to calculate and populate the field, based on birthdate and a test
date.  The property on the calculated field is Fixed and ...

For example if the values are:
1,1,2,3,4 then return 1
1,2,2,3,4 then return 2
1,2,3,4,5 then return 2

Is it possible to get a drop down menu of options when doing a query search?

I would be happy to pay $50 via Paypal to the first person to
successfully answer my question.
I am using Access 2003 and Excel 2003 (I'm hoping to be able to pull
the output of the following query into Excel).  I have two tables and

Is it possible to make a passthroguh query updatable?
I think that it normally isn't because it doesn't know the primary key, but
is there a way to specify it?

I have a ClientSampID that looks like this:  T2/LA-10-(0-6)
I am looking for a statement that will pull the text after the "/" and
before the first "-". Example: LA
There may be more than 2 characters after the "/" and before the first "-".

Is there any way to run all of the queries that are in a group?  I could
always make a macro that runs each query but it'd be easier if there was just
one action.  I have about 40 update queries that need to run.