I need to run a report that queries two different tables. One table list
16,000 physicians (table 1) and the other table list 500 physicians (table 2)
on my medical staff. I need to know which physicians in table 1 are also in
table 2.

I made a query and it runs fine. But when I tried to save the result by
changing it to a make-table query, I got the message box "Invalid argument.".
The SQL statments are:
SELECT IP2003_04.*, MasterLookupFSAs.KEYFSAS INTO IP0304KeyFSAs

   I am attempting to locate records that have an account name that starts
with and asterisk.
For example
** do not use **

I have a database field that is currently like this: Carter, David E
I need to put them into seperate columns for a First Middle Last.  Can this
be done?

I am creating a unbound form.  I also have about 7 reports.
Parameters are set on all these reports to either display CAT FIN, COSO,
M&E, or all.  
So if you type in the parameter the one of the above, or all of the above

I have just switch over to ADP with a SQL backend. I have two tables
AirspaceMissions and Bombdrops. Every mission might or might not have dropped
bombs. I want to display all the Missions that flew and have the BombDrop
fields be displayed so the user that is updateing the ...

I have several fields in a database that I need to change.  The orginal date
in the filed "DOB" Date of birth was entered with only a 2 digit year.  Such
as 6954 or 101254 which should be 06/09/1954 or 10/12/1954.  So I need to
insert the two digits 19 into these fields and ...

I have a inventory database. I like to know the PO and SO quantity.
i.e. I have 5 items, item1 to item5
item1 PO001 5 p.c.
item2 PO002 3 p.c.

I am currently merging multiple SQL tables. One table has customer info and
the other table has products the customer ordered. Everything pulls in ok,
just that if a customer has ordered more than one product, Word will print
one order than the other. I would like for multiple ...

Hello to all
I am using Access 2000 and have created a crosstab query that uses
date/time field for the column header and a unit field for the value
The date field is from one table and the units are in another table

I cannot figure this out for the life of me.  I looked over the boards,
but didn't find anything that would help.  Also, I am just learning
Access, so please respond with idiot proof directions, and thank you in
advance.

Okay I have a table that lists products and all their prices.  In addition
there is a field that lists the "status" of the item (sale, full price).  I
want to have a query that shows me just every place the status changes and on
what date.  The problem is that an item could have ...

I got a query which I am running from access sql window.The
tables are linked. When I am trying to run the query, I get a syntax error
stating the error is in the from clause.
I cannot figure out why this is so. I appreciate any help in advance. Thanks

I built an ASP.NET page for an access DB I created. I have a query that does
exactly what I need it to do in Access but when I try and use it to populate
a datagrid I get a parse error at the '<' symbol. Could anyone perhaps point
out where I may have gone astray? This is the ...

I need to figure out a way in access to give sequential numbers to different
records based on another number (increasing in order) for each person. For
example, Jane Doe has 5 records and I need those to be numbered 1-5 based on
the numbers (or IDs) 97014, 97015, 97016, 97017, ...