How to create a table with the fields Name, first name, address, etc,
starting from 3 tables of 3 different bases and avoid repetition of names?
Thank you for the assistance.

I have a  month diary report that prints a diary of events. It makes
available blank
space for days with no entries so that the user can hand write in events
while away from the office, that have just the days date heading. To do

Currently I have this query:
SELECT tblSiteSetups.CombinedStorefront, *
FROM tblSiteSetups
WHERE (((tblSiteSetups.CombinedStorefront)=Yes) AN

UPDATE GIS_EVENTS_TEMP SET GIS_EVENTS_TEMP.FSTHARM1 =
HarmfulEvent.HarmfulEvent
WHERE (((HarmfulEvent.UnitId)=1) AND ((HarmfulEvent.ListOrder)=0) AND
((GIS_EVENTS_TEMP.CASEID)=[harmfulevent].[crashnumber])),

I wrote a bunch of SQL statement in SQL SERVER and now im trying to do
the same thing in access. OMG what a pain that Access can't handle
updates or CAST() the way SQL server can. OK I thought I wrote
everything in Ansi standard SQL statement so it should be compatable?

Hello.  I've made a minor change to my db and now I can't figure out how to
make a change to sql.
I'm now allowing for 2 email addresses. I'm using EmailFlag which tells me
if I'm to use EmailName1 or EmailName2.  Before I just had EmailName.

I have a table that has the following fields
item
location
qty

I have a query with the following 3 fields:
Customer     Item #    Qty Ordered
There are 5 customers, and up to 100 items.  I want to filter the top 10 for
each customer.  Currently the query is sorted by customer name, then

I'm using the following query
SELECT job.job_skyjob, sky_promocodes.promo_id
digibox.*, customer.*, engineer.engineer_code, job.
FROM ((sky_promocodes INNER JOIN (job INNER JOIN custome

I want to append a single record from a query in one database to a table in
another database, when I click on a button I label Complete.  This button is
part of the source table the query runs from.
The source query is Completed Awards, it shows me all records in a table

I am attaching to an external database using ODBC to run a query. The
external database store the sales information. It has the customer number,
date of Invoice, Order number, product number, line number on the Invoice,
quantity, cost, selling price and the total margin on the ...

This is the problem that I am running into.  I have different facilities that
I send staff to, and each of these facilities have different pay rates per
shift per licensure.  What I need is a calculation that grabs the right
licensure with the right shift and displays the right ...

(Newbie request)
I have defined a table where IDNumber is Indexed (Dups OK) and ReportDate is
not indexed, but I want to create a query that returns the other data based
on these fields and updates the form.  If there is no record for that

I need to use a wildcard type search to mark records that have
particular letter in a larger field: IIf([studentcode]="*V*",1,0).  I
this example, the format of the studentcode is NNL-NNNN where N is
single digit number and L is an alpha letter.  I want to select al

I'm having a problem that I was hoping someone might be able to help me out.
I thought it would be straight forward, but what I'm trying to do is this.  I
have two seperate queries, and want the total from query "A" divide by total
from Query "B" and display the results in ...