1. I need to know how to update the field list of the query after
adding a new field into the table and the query?
2. I need to know how to update the records table after adding
calculated filed?

e.g.-- In my main table I have a column, Categories, with a pull down menu
with 3 selections, "Auto", "Household", "Medical".  Then I have a column,
Item, in which there is also a pulldown menu which will display only items
associated with the specific category selected in the ...

I have an unbound form with 9 calculated fields which display business
indicators. Some calculations are DSum from tables in the DB while others
are calculated from these (DSUM) values on the form.
The form can be opened from a Menu and from command buttons on two menu

Info:
I have a data access page that i created in Access 2002, it is based on a SQL
query also created in Access 2002.
Here is the code SQL code:

I have two working databases that have the same fields but different data.  I
was wondering if there this a way of doing a "compair differences" of the two
tables so I could see what data is most current.  Let me put it this way, I
would like to murge the two tables into one.  Is ...

I am on the lookout for a Training Database.mdb - to keep track of
employee training, for generating training needs employee wise as per
different training categories such as  Technical, Management
Development, Safety, Environment, etc. Any help where I can get one? I

How do I accomplish totaling a column from a subform onto a text field
in the parent form?

Recently, I create a new database (datasheet) and following that I have
created an electronic form where all my field are listed. I have a very
particular question and I would appreciate if someone could help me to
resolve this problem.

I would like to put an Outlook style calendar in my Access database to make
managing appointments easier. (I can not guarantee all users will have
Outlook so I need to have the calendar/diary within the database.)
I couldn't find any info in Google groups, I thought there would be ...

I have a table that has following fields: 1) account number 2)assiciated file
name and 3) description of file 4) file path.  Filenames are formatted as
account number with 2 digit alphanumeric code following (i.e. 12345a2,
67890b1)

I have a customer form with a drop down combo box for "city".  It displays
city, state and zipcode.  How can I select the city and have the state and
zip fields fill in at the same time?
Thanks for any help

I have a strong feeling this is a simple question, but I have been on
this computer so long my brain has fried!
I want to bring 2 tables together in a query. Both tables (these store
records of appointments made) have the same fields - one has data that

I have a duplicates query like this
SELECT Companies.CompaniesID, Companies.CompanyName
FROM Companies
WHERE (((Left([Companies].[CompanyName],5)) In (SELECT left([CompanyName],5)

I have a query that takes all of the transactions for suppliers for a period
and sums the total values of each transaction to effectively report a balance
for each supplier.
This works fine for most transactions, however when invoices and credits or

OK I have four table and this is how they are laid out:
Students Table
 WID (PRIMARY KEY)
 LAST NAME