query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
example

name from time to time
b a 10:30 b 11:50
a b 12:30 c 12:40

I want a query to find
name from time to time
a aa 10:00 b 11:00
b a 10:30 b 11:50
a b 12:30 c 12:40
 
What you mean by "last record" may not be what Access means.

You can use a Totals query to find the Max() value of some field, using
GroupBy for the personID.

However, if you have ONLY recorded time, and not Date & Time, the "last"
time may not be what you were seeking...
 
Hi Jeff
I did what you said but I got the right fields (name and time) and wrong
fields (from, to) ,, what i need now is matching between the fields of record
according to the name and time
thank you in advance
 
Back
Top