I have a table that I created in Access and I also have created a report to
display the information I want from the query, but the report is showing me
more than what I want.  I have grouping specified on my report to groups
records based on the same date and city.  However, I ...

I'm trying to run an access query using a function I created to tell
the query what path to use.
Public Function QueryVar(ByVal sPath as String) As String
   QueryVal = sPath

I have a query where some results may be null.  In this case, is it possible
to set a criteria to allow the query to return a result for a null value to
equal some text value?
For example:  If null then = "Unreviewed"

I have a query with approximately 20,000 records.  3 of the fields (qty) only
have about 3,700 records and the rest are blank.  Is there a criteria
expression that will populate the blank records of these fields with 0 (zero)
within the same column that states if the field is ...

I have a selection form with a pull down menu of courses listed for that
person.
I want to make it so an "Admin" can see all courses but other users only see
those specific to them.  How do I do this in a query?

I have a query that works in Access but when I convert it to Excel, I get
errors.  Can someone help me with converting this to MS Query SQL Excel 2003
language?
Here is the original Access coding:

I'm working on a query that bouncing dates against one another. I think it
needs nested IIf statements, but my brain just can't seem to put it all
together. I'd like it to work in a single query to keep things trim and
because I'll need to modify it for 8 different cases.

I have two tables
-Individuals
-Participation
Participation table has two fields

I have two tables (this all has to do with drilling).  The first table
consists of a drill hole label, from depth, to depth, and geology (i.e. what
rock is present at that interval).  My second table has a drill hole label,
sample number, from depth, to depth, and nickel content. ...

I have a query that has personnel members with their respective departments
and additional info. I want to selectively download to Excel all personnel
but each department in their own spreadsheet.
Example: All departments starting with A will be downloaded in sheet A, all

I have a table "Rates" with the following data:
StartDate: 5/15/08   End Date: 6/23/08  Rate: $53
StartDate: 6/24/08   End Date: 7/15/08  Rate: $86
StartDate: 7/16/08   EndDate:  9/19/08  Rate: $99

Hi to all,
I am getting a data type mismatch in the following query in the where
condition:
UPDATE tblBudgetBr SET tblBudgetBr.[To] = DateAdd("yyyy",2,"Date()")

I have a query with the following data.
completion date, part category, avgLT, countOrder
Completion date in format of m/dd/yyyy and there are over thousand of records.
I would like to format it so that the completion date is grouped by month

I'm in the process of developing a report in Access, through an ODBC query.  
The sourced data comes over as follows:
Part               Month        Qty Sold
ABC                  1                200

=DATE(YEAR( [Employee Information Master]![Original Hire Date] ),MONTH(
[Employee Information Master]![Original Hire Date] )+4,DAY( [Employee
Information Master]![Original Hire Date] ))
This query returns the error that there the expression has the wrong number