Last OFF

[Waqas ali]

Dear all,

i have emp table.in this table employees have off in different dates.
now i want to build a query that inwhich date an employee got his last off.

for example one employee got off 01 aug , 10 aug,18 aug and 24 aug
how can i know his last off in 24 aug

 

[Joe4]

Take a look at creating an Aggregate Query (details in Access help).

If you add the name and date fields to the query, and click on the Totals button, it will add a Totals line with the words Group By under each of the two fields. Changed the "Group By" under the date field to "Max" and it should give you want you want (the latest date for each person).

 

[Waqas ali]

thanks i go it.

how can i get below option in access? can i record macro in access?
A lot of VBA code can be acquired by using the Macro Recorder.

 

[Joe4]

how can i get below option in access

Not sure what you mean. Can you explain, maybe give an example of what you want?

can i record macro in access?
A lot of VBA code can be acquired by using the Macro Recorder.

There is no Macro Recorder in Access, but there is a Macro section to create macros. You can then in turn convert those macros to VBA (there is an option on the Macros toolbar/ribbon to "Convert Macros to Visual Basic").