How do you update all of the records in an aliased table that is part of a
query? I have a real table (that the aliased ones were created from) that
contains record changes that I want passed to the aliased ones.
John Kraus

The following reply from Jason Lepack to a previous question sets out
how to normalise a design:
"A normalized design, if you're interested, is
to have 3 tables.

I have a table with a date_created and date_expired and I want to
look
at the 15th of each month and every month since the system started
and

Is there a way to set an SQL Result As Variable?
The reason why I want to do this, is because of a date comparison.
An example: if the date variable is 1-1-2007 and the other date variable is
also 1-1-2007 then .....

My queries as below;
SELECT NetName, Date,Hour, Sum(Total) AS CG0, Sum(Total) AS CG1
FROM totalcc_hour
WHERE ((([CC])="000" And (([CC])="010" Or ([CC])="011" Or ([CC])="013" Or (

I need to update an access database each day, with stock and price info, and
then update it online.
Is there a way to compare the before and after tables, and make a new table
with only the changed records (only the changed fields!) plus the primary

I have a couple of subforms : (Diagnoses, ActiveOrders)  on a main
form (Residents) and I wish to be able to associate a diagnosis with a
particular order.
The diagnosis field on the ActiveOrders subform has the following

i am trying to run a piece of code that i know works to look up the
value of a query stored in a table, but when i try to run it, i get a
runtime error 2001 message. can anyone help me? the code i am using
is: If Nz(DLookup("admingroup", "group"), 0) = 2 Then DoCmd.OpenForm

I have an access 2k database in which I need to count groups of
records of individuals by that age groups such as
14- 20         no of individuals
21-30          no of individuals

How do I create a sum column to add all the months.  Problem: whenever the
field is zero, the total excludes in the sum.  Please see the SQL statement
below:
INSERT INTO [YTD PRODUCTIVITY REPORT] ( Type, [Atty #], [Atty Name], Hours,

In a current table, the values in a particular field are all items like:  
MD45 Tuesday PM
or
TX341 Friday AM

I created a query with two tables, ID numbers in common. I joined the IDN in
both, but only the information from one table is showing in the results. I've
done a hundred other queries like this. Did I "set" something that I
shouldn't have? Hope someone can help.

I get 9 records when I get Top 5 because there are some matches or ties ...
is it possible to get rid of these, it is driving me crazy.
Please help,
Thanks

'm using Access 2003 and my queries are summing a portion of my data and the
others are left blank.  Below is a copy of the query with issues:
Sum(IIf([NSS]="Pilot" And [Rec Month]=#3/1/2007#,1,Null))

I received a file consisting of 174 original records that we want to delete
from a table consisting of thousands of records.  How can I write a query
that will match and delete each of the records without having to write a
separate query for each record?