This question was previously posted in the reports section.  However, we
thought we might get better response here in queries.
We are seeking a best way to develop a query or queries and corresponding
report that involves multiple columns across and includes sub columns.  The

I am receiving this error when running the following query:
UPDATE [T1001 Claims] INNER JOIN CLMPRDFIL_RCPDTP ON ([T1001 Claims].DQOINB
= CLMPRDFIL_RCPDTP.E0OINB) AND ([T1001 Claims].DQP2NB =
CLMPRDFIL_RCPDTP.E0P2NB) SET [T1001 Claims].[Claim Cost] =

I have what I hope will be a simple question. I have a form that allows me to
run a report based upon one of two criteria. The two fields are these
[Employee] and [CertEXPdate]
How do I word my selection criteria in qry so that if the employee field  on

How can I write a parameter that asks the user to specify if a field is null
or is not null?
field: commission (currency)
the criteria is null works just fine in the query design, but not in the

I  have a problem with creating a control that could lookup and indetify a
missing coresponding record from one table. I have one table that has a
subtable, i want to create a control that will notify me (user) of a missing
record in a subtable. I tried with iifnull function but ...

I created a form (Form A) for running queries. The form requests a start date
and end date and one can then select from a list of queries. The form works
properly. I then created a second form (Form B), which is an exact duplicate
of the first, except that criteria within the ...

This is really making me nuts...
I have a small form with just one combo box named "HFC" in it. I have the  
combo box listing choices from the table named "HFCS".
I have a query built in the first row I have Transplant* "which is the name

I have the below query and I get the below error message.  For the life of me
I can not figure it out.  Any help would be greatly appreicated.
Query:
SELECT 810_HEADER.*, 810_DETAIL.*, 810_SAC.* FROM 810_HEADER INNER JOIN

I tried for hours at work, today, to get this to work but I just do not
understand enough to determine how to write this in the query design window.
We have a table that contains employees' last name, first name and postion.
We have another table that contains employees' last name, ...

Where is the security in Microsoft Access 2007 ???  In previous
versions you could set up passwords and privileges for Users and
Groups of users.  How do you set up some kind of security so anybody
who uses it can't just delete the database ?  I want some users to be

I have a four value example A, B, C and D.
Value A=56,
Value B=70,
Value C=80 and

Hello, everybody!
I have a table which consist three fields:
1) Name of the person
2) name of the page visited ( just two variants, people can shoose just from

I'm trying to create a Reconciliation database.  My database has a field
called status.  2 queries, 1st called Matched Query, 2nd UnMatched.  User
will import two different files.  One from the bank, and other accounting
software.  I want the Match query to return and auto fill the ...

I am the database person for an art school with an Access 2K database
with many linked tables.  I need to constuct a query to produce a list
of all the past classes with an enrollment of less than 2 students.
How do I construct this query?  I have the linked tables a

Say an input form stores data in these fields in tbl_Time:
EmployeeID
Date
LaborHours