I have a table of 6 field ,, the first one is ID ,, and this field is
ferquent many times in the table ,, what I need is to obtain a new table
which include the last recrods for each ID according to the last entry or
last time for the ID,, I make the query and bring the max time ...

I have two tables. Table A is student records with a unique student id.
Table B is each students weekly lunch selections, again with a unique student
id.
When I join the two tables with a query, utilizing the student id from table

I am trying to build an expression in a query that will show dates that are
greater than the due date in one field and is null in the second field which
is the out date.  We are putting this expression in the criteria of the out
date field.  Can anyone help me?

I was wondering if anyone could help me??
I am trying to convert a field in my db from a text field to a date field
using the following expression:
CDate(format([warre],"Short Date")).  The date is currently stored as 060401

I am trying to calculate the sum of the cost but the data I have has negative
values that in this particular instance I do not want to count in my total
cost. Is there a way to write an If Than statment that will make all of the
negative values equal zero or not be counted at all ...

i have a table contain 5 fields with primary field that i want make query
which breif the table according the field,,, the fields are as example (
name, from, time, to time) and  the field name may frequent in the table ,, I
need to obtain the last record for the name

I have a query that sorts through one table to produce a form, but I need to
somehow make the same query produce the form from 2 tables. The query
basically sorts the information and has not criteria for one column..I have
no clue on how to get the query to run off of both tables. ...

When I run a query using two joined tables, I can't edit the data in the
field or if I make a form using the two tables, I still can't edit the data,
but the query is shows all the data fine.

Access 2003. I want to Time Stamp changes to records in a table. I have been
using the Now() function, but the only way I can get the field in the table
to record/display the Date AND Time is by setting the DataType for the field
as Text.  I view this as backwards thinking, and ...

I have a query that prompts the user to enter a specific type of data.
i.e please enter a training type : (I Enter) *Fire*.
What should happen is I get a lsit of all people whom have not had any fire
training however I get a couple of anomolies come up, the results include

I am using Access 2000 and have a Make Table query that delivers the results
of joining several tables so that I can manipulate the results without
affecting the original data. One of the fields in one of the tables is set to
Autonumber.

I have entered my weight twice a week into a table. I want to be able to take
the 1st weight and subtract the last weight from it to get my weight
loss/gain. Can someone help me?

New to this so be easy on me.
I am trying to build a query that will pull up information from th
last two dates entered in a database (this will not be consecutiv
dates).  Any ideas on how to accomplish this?  Thank so much everyone

Does Microsoft Knowledge Base Article - 201982 RE: Access
2000 Count Function Ignores Null Values apply to Acess
2002?  I can duplicate the problem the Article refers to
but is work-around does not work.  The SQL solution

I know that in a crosstab query you can only have one value field.  Is it
possible to create a form or parameter prompt to ask the person running the
query which field to use between three options?
Thanks!