I'm tring to build a query that will count the number of checkboxes between
the dates of two other fields. I have two tables within the query. One table
(tblInspection) contains InspectionID, InspectionDate, and Citation, among
others. The other table (tblReinspection) contains ...

After I run the report and then click on analyze it with MS Excell, it always
save to C:Mydocument.  I want to change the location of the file to G:Report.
How would I do this?  Thank you inadvance for your help.

in access query:
i have a text field that express percent as ex. :2.5%
I want to convert this to a number. I've tried changing the underlying
table's (a linked table) field type to numeric but get whole/rounded numbers

I created a tabular report from a crosstab query and I have since
deleted certain rows, added a column and changed some things but the
report has not changed at all. I don't quite understand why.
Grant

I have created a couple reports from Crosstab queries and when I go to
sum up the columns I seem to get the number of rows as the amount
every time.
For example:

I created a crosstab query where the first row is a count of all the
fields that are blank. I would like to remove this field from the
query.
Thanks,

How do I pass a parameter to a stored procedure in a pass thru query?
I'd like to enter the parameter in a control on a form and then run the pass
thru query and pass the parameter to it.
I've tried this, but haven't been successful.

Simple problem but I can't figure out what I'm doing wrong.  I have an
employee lookup list that will not alphabetize.  When I use the employee name
table for the row source type, I get the full list but it's not alphabetized.
When I use an alpha query that I created from the same ...

I have a simple query to retrieve information related to the employee ID
entered in the parameter entry pop. I recently started getting the same pop
twice while trying to run the query. I have the [Enter Empl ID] in only one
place, but if I don't enter the same ID in both pops my ...

Hello, I need some help.
I have a query called "Client Services" and I am trying to have access ask
me for which staff to pull records from. Any ideas on how this would look.
Thanks-

I have this query which works fine when the start date is 1/1/2007 and end
date of 7/6/2007.  When I use a start date of 12/31/2006 and end date of
7/6/2007, it returns no records.
The Received field is coming from a linked exchange file/inbox with the date

Here is my situation.  I have a query that needs to return data depending on
certain criteria.  There are 3 date fields that the query has to look at:  
BOY, EOY and MOY.
If all 3 fields are blank, I don't want the query to display those records.  

I have a querie that has a Start Date (MM/DD/YYYY), Start time (00:00:00),
End Date (MM/DD/YYYY) and End Time (00:00:00) Fields.  I need to calculate
the amount of hours and minutes that have passed from the Start date and time
to the End data and time.  I need to do this in ...

I have a report that needs Demographical Growth Rates for Historical,
Current, and Recent population for One-Mile, Three-Mile and Five-Mile radius.
I also need to locate the Population for that area. Where would or how do I
begin this?

Hello, I have an Access application that links to SQL Server.  One part of
the application allows for building lists of contacts.  As you're building
the list it stores the person id (ContactID) in a front end table.  When I
try running this line of code