I'm trying to run a single query that will give me the count of records in
each of three one-to-many tables.  The first table consists of claims, the
second of invoices and the third of line items.  The relationship is such
that one claim will consist of several invoices and each ...

I am looking for SQL to rank the following data based on premium.  Highest
premium = rank 1 and so on.  Any ideas?
Policy Key    Company Key Total Vehicle Premium
0    5    1801

I have a crosstab query called "qry_case_cross_crosstab" that runs against a
table just fine however I need to change it so that the results are narrowed
by using a date range.
So I created a regular select query called "qry_case_cross_crosstabSOURCE"

I am importing an excel spreadsheet that I need to normalize so it can fit
into my database.  Since I will get a new spreadsheet every month I will need
to repeat the process.  I figured it would be easier to write a query or
series of queries in Access to convert the spreadsheet ...

I have the following expression but want the criteria to include 2 fields:
IIf(IsNull([HR]),2,1)
If HR is null AND NARC is null I want a 2 otherwise a 1.  
Thank you for your help.

I need some help with a query I'm trying to write.  I have two tables with
customer information, tblA and tblB with unique identifiers tblA.id and
tblB.id.  I'm trying to write a query to return results of everyone in tblA
who is NOT in tblB and vice versa.  Here is an example:

This is very strange. When I build an IIf expression in query design view
access (2003 first, and then upgraded to 2007) is changing the commas to pipe
characters. I then get 'invalid use of pipe character in query expression'.
If I change the pipe characters to commas I then get ...

I've got a problem with a query, mainly how to get the right value of
[dYear]. I have two tables (simplyfied) with the following fields:
TABLE 1 (tblEntries): [Id],[EntryDate],[Place],[Variety],[Weight] (e.g. a
wharehouse entry)

ow do this in access  
=RIGHT(A3,LEN(A3)-FIND("\",A3,FIND("\",A3,FIND("\",A3)+1)+1))
A3 being a field in access

The government agency where I work is changing the way it tracks labor cost.  
We used to use a flat hourly rate for every employee.  Now we are going to
use each employee's actual wage rate.  Each person MAY receive a "step
increase" on their anniversary date which is, of course, ...

I have a Percentage total of 101% on a report.
There are two rows in the report that each return 1%. This added to
another row of 98% (98% + 1% + 1% = 101%)
Do I need to change these two 1% via rounding/decimals?

In a query I have the time the activity started [TimeStart] and the duration
[Minutes].
I would like to create the field TimeStop:[TimeStart]+[Minutes]
Activity started at 12:00, the duration is 90 minutes, the time it stop

When I create a new query and pull in an existing query, all that shows is a
* and all the fields in that query are not listed.  When I open a query based
on a query, in some the fields show up and in some they don't and the fields
have Expr in front of them.

I have a query with multiple columns of numbers and several hundred records.  
I would like for the query to return one row, containing averages of each of
the columns.  I have done a query that contains the averages at the bottom of
the column, but would like to get it to just ...

The excel sheet that is used to import into the database uses 90601 as the
date format, which represents June 1, 2009.  I would like to create a cross
tab query with column headings grouped by 0906 (for June data), 0907 (for
July data), 0908 (for August data), etc.  What is the ...