I have a table with the following:
AutoNumber    Course Name (a text field)
I want to add a Section Field that increments beginning with 001 all
the way to 999, for Each UNIQUE Course Name.

I am having trouble working out how to update a field on an open form
with a calculation based upon calculations from other tables!
For example, I have 3 tables:
Diary

hey... i have a 12 or so page report where each page is quite different from
the others.  the 20-50 controls i have on each page, however, are similar in
that they run on monthly and quarterly date intervals.  what i'd like to do
is to be able to declare a text box or something ...

Not that I'm going to go out and buy a new motherboard, but, will a dual
processor PC run a huge report query and still allow a user to use other
programs while the query is running?

Hope someone can help me here.
I am fairly new to Access. I have set up a database relating to vehicle
movements prior to sale. I have a subform based on 'locations' table
which is linked to my main 'vehicles' tables through vehicleID.

Does anyone know if stacked column charts are possible in Access and if
so, where I can get some information on them?  They don't appear as one
of the choices in the standard Access graphing tool, but I'm hoping
there is a workaround.

I have two tables plus a junction table
Table1=Aircraft
aircraftid (pk)
year mfd

So I've been playing with combo boxes and subforms.
Finally, I can make a selection in a combo box, and have that drive an
after update event to open a query or a form.  Works famously.
Now the next step is to bury the form in the same form where the cmb

I have a client whose Access 97 tables have been corrupted at sometime,  
but the application still functions.
They want to know whether the errors all occured on one day in the past,  
or whether they occur from time to time (and so may happen again!)

I'm wondering how experienced database designers deal with practice
data.  Once a database has been designed, built and tweaked, what does
one do with any practice data that might have been used.  Do you just
go through every table and delete meaningless records?  It seems like

Is there a way to have my report open up in a size that is completely
viewable.  For instance, I have a report that when it opens up (100%) I have
to scroll from side to side to see all the data.  Is there a way to have
this report open up, say, 75% and is there a way to make it ...

I am reading a book (Beginning Access 2002 VBA) and I am having a problem
understanding the use of recordsets.
Can anyone explain the value of creating recordsets or how they are
practically used?

I'm trying to produce a report based on a dynamic crosstab.  Ultimately
i'd like the report to actually become a sub report within a student
end of year record of achievement.  The dynamic sub-report will capture
what grades the student has achieved in a list of different subjects

I wondered if anyone knew if it was possible to delete entries in an MS
Access database table from just entering data into it?
I shall explain :
If you have a web form (in asp.net for example) where you can enter

I'd like to have a way to add bidders who have won at least $1000 in
the last auction to my mailing list. I'm having trouble with the
update step.
To find bidders who have won at least $1000 in the last auction, I