I have a date field in a query pulling from our ERP system.  I've used a
between statement in the past to get the data I need.  I now have a need to
calculate last months start date and end date.  I'm trying use the following
between statement but it doesn't work.

I would like to select records of dependents born prior to Jan 1 1986.  My
fields are Dep1, Dep1DofB, Dep2, Dep2DofB, Dep3, Dep3DofB etc.  I need all
dependents born prior to Jan. 1, 1986. How can I ensure that I get anyone
from Dep1 and Dep2 and Dep3 etc. that are born before ...

I need some help on generating a number with an update query.  I have run
the query and the query runs and will generate a random number each time I
run the query.  I'd like to have the numbers generated with only one click.  
The below code is in a mod and the reference to the ...

I have problem with a query not returning all matching records.
**** Design of Db******
I have three tables and three forms (Audits, Findings and Notes).  Each form
feeds the namesake table.

I am trying to create a query from multiple tables with the same number of
columns and same headings to pull all records from each table with a matching
value in one of the fields. This database holds all the information for each
job we have in progress with each table ...

I have a query showing result like
ID  Year          Field1         Field 2         Field3
1    2005         Y                                       Y
1    2005                            Y                          

The following query returns the error "Data type mismatch in criteria
expression" and I honestly have NO CLUE why this doesn't work:
SELECT * FROM      
 (SELECT * FROM qryProjects WHERE qryProjects.ID IN

Until recently (2-3 months ago) I never noticed this problem, but now when I
make a query it pulls ALL the fields from all tables in the query.
An example:  I ask for a listing sorted by Last Name, First Name.  Two
fields only.

In my table I have a column called "Completed" which is defined by a yes/no
data type.  I want to create a query to only populate those records that are
checked as being completed.  With my current query layout, it is generating
all records although the criteria has a value of ...

I'm trying to provide some flexibility to a SELECT TOP query. I'd like the
user to be able to pull the TOP 3, TOP 5, TOP 20, or whatever. I tried a
parameter:
SELECT TOP [Enter Number of Returns]...

Is there a way to use the datediff function to return in results in a
minute:seconds format?  Example 03:30 for 3 minutes and 30 seconds.
Brent

I currently have a parameter query that runs from an unbound form where I can
select from 95 different criteria and then run the query.  This is great, but
I would really like to be able to loop through the 95 criteria without having
to select each one individually.  Is this ...

I have a name field that is text in a personal type address book database.  
Some relatives keep their own names when they marrry and I would like to
build a querry that picks up any record that has either name.  For example,
if Joe Smith marries Jane Doe and field contains name ...

I've got a .txt file that is imported into a DB.  There are 100+ fields in
the DB and that data types are text, date, memo, currency, number, pretty
much everything.
My problem is that some of the fields, not all, are in ""s.

Just a quick one (i hope).
I have 3 column in my database. (Mach1, Mach2, and Mach3)
Each column looksup values using a combo box.
There is a 4 column also. (MachGrouped)