I'm new to Access and what I'm about to ask may be very
simple and basic.
I have a table (AA) with an autonumber column (aa).I need
a query to get the last row of table AA, or at least the

I can list records of grades using the report generator.
Simple, but I have a problem to show who is number 1,2,3
and so on without sorting.
If ms excel, that is easy; one simply rank the column

Its been a while since I have had to create a new Access
database, and while
I can swear I am not doing anything wrong, Access insists
that I am.

Lets say I have several databases with tables in them. I
created another database with a table to hold all the
information from the other tables in order to streamline.
How can I bring the information from the other tables into

I have a form field which has a value of say, 50 (numeric
value).  I also have a table (tblLaborRates) which has a
few records.  One of the records is ID 6550.  In that
record is a field named "Rate" which contains a value

Whether through form or vba, table will not accept new
records.  If I manually open the table and create
a "dummy" record, any method of adding a record will work
fine.  Is there a way to omit a dummy record and still

I am about to redesign a school database, the original is a mess with
all data for children and parents being in one table. I am trying to
come up with an efficient way of modeling a family allowing for the
possibility of seperated or divorced parents

In access97, is there a way to link to an access2000 table

I have a Month field that I would like to sort
chronologically instead of alphabetically. I created a
MonthNum field which would store "1-12" based on the month
entered in the Month field, and plan to sort the

Thanks for reviewing my question.  I would like a little
help understanding what I actually do with a junction
table.  I understand to create a junction table you take
the primary keys from each of table and put them into the

In a table, how do a make a cell autopopulate with the
value the is in the cell above it.
For example I have 10 rows of weather data (wind, cloud
cover, temperature, ect).  For each record the temperature

i try to change an autonumber with "New Values" set to
Increment by code (using tdf.fields
(xxxx).defaultvalue="GenUniqueID()").
However, when i put new filed in this table the new values

I'm trying using sql to insert into a field a value in a
table, in this table i have 4 fields:
[Log_id],[User_Id],[Data_in] and [Data_out], when i enter
the db i fill fields [User_id] and [Data_in] and the

I am pretty much a newbie and I am trying to design a
database but I am a little confused about how I am
designing things.  It is my understanding that if I want a
many-to-many relationship between two tables I generally

What is the maximun number of tables allowed in Access
2000?