I have a query that depends on a form being open.  If the query is
inadvertently opened without the form being open an error is generated but
it's not possible to close the query - it gets stuck in a loop of displaying
the error message and then going to debug.

Hi dumb question...
I have two queries... same fields ... different dates... trying to put into
a union query...Is there away to get all the fields in the query without
typing all the field names?

Please, can somebody help me? I am using a form to take in parameters
for an Access query.  The values are entered into various text fields
in the dialog.  Is there a way that I can ignore any text fields which
are left empty?  I tried using this in the criteria but it doesn't seem

I am trying to count the days in a query.  I want to only count each day as
1, even thought there could be more then 1 record for that date.
Example of data.
Date        Wave

I have two tables:
tblOrganizations
Organization
OrgID   PK

Please, can somebody help me? I am using a form to take in parameters
for an Access query.  The values are entered into various text fields
in the dialog.  Is there a way that I can ignore any text fields which
are left empty?  I tried using this in the criteria but it doesn't seem

Can you tell me which one of these queries is the best to get the quickest
result?
Q1=  "SELECT * FROM Table1 INNER JOIN Table2 ON Table1.Field1=Table2.Field1
WHERE Table2.Field2 ='hello' "

I have a main form (called "employee") and a subform (called "department").
The two forms are connected using "EmployeeID" and I want to update the field
[rate] in the "department" subform from another table called "Sheet 1" (which
is temporary). "Sheet 1" has two fields ...

I have a one to many relationship and I want to delete all records in the
"many" table EXCEPT those records who have the most recent date. Having
written this it has occurred to me to have a "NOT" criteria.
How would I write it? I know it is a simple thing but need to be sure!

Any suggestion for how I can make this query run any faster would be much
appreciated. It is set as a Make Table query as I need to run further queries
on the output and it is already painfully slow.
SELECT tblChWidthSumm.ID, tblChWidthSumm.LocCode, tblChWidthSumm.RevItem,

Does anyone know of any downloadable programs that can be used to send
free SMS messages from a computer to another persons cell phone??
Thanks!!

Tried to download two new versions of this to replace the one i had
which was not functioning and now none of them work!! What can i do to
fix this??

i need to extract some text from within a field but the word i need to
extract is in the middle of the text and contains differnt amounts of
characters, therefor the MID expression does not work. i need to modify this
some how to return all text between word A and word B. Can ...

Hi,  I am trying to create a Monthly Summary Report.  The only way I ca
get the information correctly is to create three different queries.  
would like to create a report based on 1 query.  I have tried to make
query with the relationship between the 3 queries linked through ARE

I have database with medicare patients that needs to determine the length of
stay and number of  patients by month.  The data looks like this:
Pt#    Start dt    End dt
123   1/4/06      3/31/06