Using an access query I am comparing a date field and a time field in two
tables (tblPermit_ss & tblExemptionsInfo). My query displays only records
that do not match.  I am using the following query and it works fine.
SELECT fldCompanyName, fldOneWorldNumber, fldBridgeNumber, ...

I need a query to count the number of days between the enteredDate and the
StartDate of each record.  For instance one record may show 5/1/05 as the
startdate but show 5/8/05 as the enteredDate.  I need a query that would show
that it took 7 days to entered this order.

I have a linked table that contains 4 yes/no fields.
Since this is a linked table from another application I cannot control the
data being entered.
The proper data entry would be to only have one and only one box checked yes.

What type of querie do i need to create in order to find out how long a case
has been open.

I need to make a query (or mulitple queries) that will allow me to see data
at the start date and then every 6 months.  I need to then put this
information into a report.  Thanks!

I have an expression (Dateadd) that returns a "Due Date" in a query.  I also
added to the expression field a BETWEEN criteria that is asking for Start and
End dates (Between [Enter Start Date] and [Enter End Date].
The reason for the between criteria is for the user to enter a ...

Another BS error with Access.
I have a form, with two unbound fields, STARTDATE and ENDDATE.
I have a crosstab QUERY, with those two fields as criteria for the query.
I have those two variables in Query parameters.

My query is not retrieving all of the records that should be included in the
dataset.  I included the SQL for your review and maybe somebody can tell me
why its not working.
SELECT qryReportData.Order, qryReportData.[Created on], qryReportData.[Ship

How can I receive table in access from cross query?
Artur

I have a set up a query that show the the following:  site #, date, comments,
and some other information.
I have aslo created a form that will run this query based on the site #, and
if blank, show all sites.  I need to add a date range to the form so that I

My query is not retrieving all of the records that should be included in the
dataset.  I've included the SQL for your review.  Please help.
SELECT qryReportData.Order, qryReportData.[Created on], qryReportData.[Ship
To List name], qryReportData.[Ship to City], qryReportData.[Ship ...

I need to use a parameter to enter a date in the following query. I want the
Parameter to also be available for a report that's based on this query. When
I use this query, it prompts me twice instead of just using the [Enter Start
Date] AS StartDate parameter that I already ...

Hello.  I want a query to return
Name (CompanyName)
Name
So, if there is no Company, leave it blank.

Trying to put in a parameter for a select query and keep getting the
following message:
The Microsoft Jet database engine does not recognize <name> as a valid field
name or expression.

Using Access 2003
Am a designing a database containing all jobs we have done for clients. Have
set up a parameter query so one can search the database for work done by a
particular client. The parameter query is set up as a form, so the client