I am creating a database to compare about 5 different tables (we will name
them Table1, Table2, etc).  I created a query to compare via Building Number
(Each table has a field of building numbers).  When I input a value (such as
building number 108), I am getting duplicate data.  ...

I hope I can explain this clearly.  I have a table that shows budget, current
month cost, and year-to-date cost for certain cost categories.  The budgets
and cost totals pull from two different tables.  
The problem is that when I run this report, the categories only show on the

I'm using Access 2003.  I have a table that includes foreign keys to several
other tables.  I'm trying to write a query that will pull data from the
primary and secondary tables.  So I'm trying something along the lines of:
SELECT a.1, a.2, a.3, a.4, b.1, b.2, c.1, c.2

I have a query that counts on a field.  There are no matches in my critera so
it results in a empty output.  How do I show a 0 in the result if no records
are found

I am trying to create a query that appends records to a table based on
the remaining percent to 100%.  I have records that have the percent
build complete on the last day of each month by station and
workcenter.  I want to DSUM the percents of the previous months and

<sigh>
ive inherited a database that is a little broken with my new job.  =]
it is relational but its not. i could go into depth and detail but  wont
unless its nessesary.

I have an update query that adds the time to a field as well as various other
updates.  I am trying to run a subsequent query that I am trying to get it to
pull all records with the current date from the date field (no problem with
portion), and with all records where the time ...

I have one table, and a few queries that I want to run off of that
table. I would also like to view the results of LEFT JOIN operations
on those queries, and do it in a single SELECT statement. It isn't
practical for me to create and maintain a bunch of stored queries that

I have an Access table with
 tmpReportIndex PgNo AcNo NumPgs
     1 0010 0
     2 0010 0

I HAVE TWO QUERIES WHICH I HAVE PRODUCED REPORTS FOR. ONE QUERY REPRESENTS
SALES FROM YEAR 1 AND THE OTHER SALES FROM YEAR 2. WHAT IS THE BEST WAY TO
COMBINE THESE TWO SETS OF INFORMATION SO THAT I CAN SEE, SIDE BY SIDE, THE
SALES FOR EACH YEAR, SORTED BY CUSTOMER.

Does anyone know why a union query would remove records?
I have three data tables that I combine to get total sales and for some
reason when I use the union query records go missing.

I need help writing a query based on Diag codes.  If I get a claim with 9
diag codes, then my table will show that claim 9 times(1 for each diag code).
I only want to see the 1st 3 codes, but I don't want to have 3 lines for
each claim,  I want to create a field that combines ...

When defining a field being used in a query, how do I convert it's
format from Currency ( typical ex. $12,575.22), to the straight number
12575.22  (preferrably without a comma after the 12)
thanks for the help

I have an Access query that contains a parameter called [AgeDate].  When I
run the query in Access, it does what I expect...it asks for the value of
[AgeDate] and then executes the query and uses that value correctly in the
calculations therein.

Hello, I have a table of 280K rows; in this table, I have many dup rows. It
looks like this:
101
102