I would like to find some TOP 3 of each Product like this following
Data Table
Name    Qty_1    Qty_2    Qty_3
A    6    12    20

Hi I have a table with this in it.
                         Feet                  Meters
1                         456.324          
2                                                102.456

I can't seem to get the MINUS keyword to work in Access SQL view. Is this a
limitation of using the SQL View to create a query? If so, what other keyword
do not work? (i.e., does INTERSECT work?)  Is there a work around to
implement a MINUS (i cannot use VBA because I want to put ...

For some reports I have various Queries setup to collect various data. I
wanted to collect a count from each Query so I ended up creating additional
Queries for each original Query. Below is the SQL for those. This seemed to
work great but was creating many extra Queries. I ...

I have a calculation in a query that gives #Error in some of the results.
Calculation is as follows:
(([Price]*(1+[Rate]/365))^[Days])
The error does not occur when I drop the end part of the calc----- (^[Days])

I have a link that a table is based off of.  I have a simple query that reads
all the information.  Now I want to connect the simple query to a table so
they are communicating. SELECT tblData.TicketNum, [RSM-Recv Query].Bins,
[RSM-Recv Query].CullP, [RSM-Recv Query].BrineP, ...

I have the following crosstab query, and am trying to make a few changes.
1) In the PIVOT line, I want to define the quarters as my fiscal quarters
(ie: 1/2/05 - 4-2-05 for Q1) rather than the standard quarters access uses
(1/1/05-3/3105).

   I have been searching crosstab and union query posts; but, have been
unable to apply the information. I am using pizza to represent my question.
There are 3 tables, tbl_pizza, tbl_veggies, tbl_meats. tbl_pizza uses an
autonumber Key. All three tables join on that key, with ...

I have a bunch of tables that either have daily data (M-F) or weekly data
(usually Fridays) with a date field.  I'd like to be able to pull this data
on different frequencies.
For example, for daily data, how can I get the last day of daily data on a

I have entered a count function in a queries with three other criterias and
it returns no data... how can i get it to reurn zero if no data was found

   I have 2 tables one is current Line orders from a Pervasive SQL database
returns 1344 records
   SELECT ORDER_LINES.CUSTOMER, ORDER_LINES.DESCRIPTION, ORDER_LINES.PART
FROM ORDER_LINES

Here is the scenario...
I have 5 local tables in Access that are growing on a weekly basis as follows:
Millions of records are being pulled manipulated and loaded from 5 linked
SQL server tables to each of these 5 local tables in question 1 to 1 through

I have a database which records training awards, completed or in
progress(status). I would like to find those people who have completed awards
'management 3' AND 'care 3'. How do I represent this in a query. I have a
progress table which documents the award and the status so the ...

I have a select query with a single number field which I am trying to sum.
The query returns 2 records numeric values are 6 and 38, which is correct.
When I select totals and choose sum for the number field instead if getting
44 I get 88. if I create a seperate query (identicle) ...

I have a list box ("LstBx1") on my "Query_Page" containing all states (by
abbreviation) in the United States.  I have the box set up so the user can
select more than one state.  I am attempting to write a query that it will
display all customers based on the state(s) indicated by ...