I'm running a crosstab query to come up with a list of clients by
neighborhood for a report. The query works fine, but now I want to
write a report using this.
Unfortunately, the boss decided the format of the report and wants the

I am building a qeury to identify how much each carrier is paid.  I
have all the elements available but not sure how to proceed from here.
Each carrier is identified by CID and within the carrier table is a
field for pay so I should be able to multiply Homes*Pay and end up with

I appended some Date values into a table with a DateTime field.  The
date values are short dates (i.e., 10/15/06)
I entered a few date stamps using the NOW() that include the present
date and the time.

I am writing an overtime program for overtime usage.  I have a table for
employees and another table for overtime hours.   I want to update the
employee table to always have the current total overtime hours that the
employee has year to date.    The hours being entered into the ...

I am trying to create a query that has one of the fields, instead of
being linked to a table, calculating a margin based on the value in a
field, [Quote_ELC_Type]. The statement is listed below. This statement
returns an #error in the Customer Margin field when running the query.

I have two tables: audit status and log
Audit Status has five columns (shows that change in status on a ticket
throughout the life of the ticket)
CR_NUM (ticket number)

I have a table with many prime numbers and each prime number may contain 1-5
rows (detail).  I am trying to count each prime number as one but when I run
the report even the header still counts it anywhere from 1-5 insted of just 1
each.  I tried to group by and then tally:1 but ...

I have to create a query that 1: shows average ballance for clients. 2:
average balance for clients for a certain bookkeeper. 3: average balance for
each bookkeeper. I can do each individualy but cannot get them to work on
same query.

Okay, I'm using Access 2003, I've run a query based on a table where I
maintain standard data (Scope Changes) and a data table (Scope Change Data) I
am using for my subforms and subreports.  The query is perfect for one
report. For the second report I needed to create a second ...

I should've been able too figure this out on my own, but I can't seem to get
any of the criteria I've seen here to work right.  Anyways this should be a
simple one for the pros.  I've got a monster table and I need to run a query
to return only the most recent records.  It reads ...

I have a database with many tables holding julian dates.  These tables were
created and loaded via passthrough queries to a JDEdwards database on an
AS/400.  I need to convert these julian dates in my Access 2003 db to
mm/dd/yyyy format in several queries.  Any help would be ...

I am creating an "events" style database (training courses) and i have a
select query that returns a count of all the people enrolled on each
course... i want to return this query data back into an existing Table called
Training Course into a column called "CountOfNumber ...

Please help!
This is a Query and I'm trying to get information about a employee
The following code works then there is the BUT!
SELECT Clock_Table.EmployeeID, Clock_Table.StartDate, Clock_Table.StopDate,

I am trying to set up a database of 'logged issues to be resolved'.  
In the the Database, there is a field called TargetDate which represents the
target date of resolving the issue.
There is also a field called Status, which is to represent the status of the

I have a very large database with a number of queries.  One of the queries I
want to add to a Macro I have running.
Why does this append query not show in my query name selection under
OpenQuery?