I use a query to generate individual P.O.s for ordering items. Usually each
order has only one acct.#, but ocasionally there are multiple acct. #'s and I
need to know the totals for each acct.#. The query that I use for this
purpose uses the following SQL:

I am looking for the definition of how to join multiple tables in queries. I
normally use SQL server and the access queries seem very complicated
Thanks,
Samuel

With much help, I have set up the parameters to select a date range for my
query.  Now I need the date range to appear on the query and subsequent
reports.
In the Expression Builder, if I click the Show box, I get an error:  You

I have a select query.  However, I can't figure out a way of determining the
number of records returned by that query.  I want to display that number in a
form or possibly subform.  From what I've read, I need to use Dcount, but I
can't seem to get it to work properly within the ...

Is it possiable to have a iif function in a query where it looks at
the next record.  for example if I run the query which lists years
and
if the results in record 2 equals the result in record 1 then it

Problem: opening a recordset in code returns only one record when it should
return two.
Details:
In VBA I construct a SQL string as follows:

I've been looking thru the posts but I havent been able to find an
example for what I need:
given that I have two tables:
NAMES with columns NAME LAST_NAME AGE

I have a query question.  I have a particular list of item numbers.
Some items have multiple vendors.  I would like a report that creates
one row per item and lists Vendor 1 and Vendor 2.  If there is a
second vendor, I would like that information displayed under the

Thank you for taking time to help me out.
I have a table containing
YearNo,*,*,*, PlayerID, Initials,*,*,*,RojterCupPoints,*,*,*
RojterCupPoints determin weither a match was won, squared og lost.

Following is my SQL and it is base on a query that I sort by date criteria.
The problem is when I change the date and there is no data for some
inspectors the cross tab does not list those inspectors in the table.
TRANSFORM Nz(Count([15 < 07].[DATE REFERRED]),0) AS [CountOfDATE ...

I have a cross-tab query that works fine as far it concerns the resulting
data. For business reasons, I need to change the order of appearance of the
row headers.
This is the query:

My data table is like this:
Type    Price1    Price2    Price3    Result
Black    2    2    3    No
Blue    2    5    6    Yes

One more question and I should be done with my first foray into Access.  All
of your help is greatly appreciated.
From my table [Resolved by Hospice Date Worked], I need to subtract
[Pharmacy Credits] plus [Credit Amount] from [Sales Amount].

Hello, my problem is that i want to create an appending query that will
transfer data from one horribly designed table to many other tables. tables
are listed as follow.
bad table!! and the data source

Is it possible to copy the results of a query to a table?
Thanks in advance.