Latest Date

[drewdt3]

I have a fleet of vehicles with a form to fill in every time they are serviced. The last field in the form automatically fills in the next service due, (6 week intervals). What I want is to draw a report off that tells the next service due without bring all the older forms out for the same vehicles.

Anyone??

 

[manojab]

I'm sure u set a flag somewhere in the table which tells u if a vehicle was serviced or not..so for ur report just call all the vehicles that have a not serviced flag & those vehicles will have the next service date on them!!

hope it makes sense!!!

 

[drewdt3]

Last Date

Thanks for the reply but I maybe didn't make myself very clear. I have 2 dates on my form when I fill it in. The first date I input is the actual date of the service then when that has been input it automatically fills in the next service due date. So all my old service forms will still have this due date on them, so every time i run the report it will bring up all the next service due dates for the same vehicles. What I want it to bring up is the latest next service due fo reach vehicle.

Hope you understand my ranting.

 

[NimbusSoftware]

SELECT Max(Table1.NextServiceDate) AS NextServiceDate
FROM Table1;

 

[drewdt3]

Last Date

Could you please expand a little further and explain what you meen by table1?

Thanks

 

[drewdt3]

query to extract the "next due date"

I have a fleet of vehicles with a form to fill in every time they are serviced. The last field in the form automatically fills in the last field which is "next service due", (6 week intervals). What I want is to draw a report off that tells the next service for every vehicle without bringing all the older forms out for the same vehicles. Is this possible and how would I write it in the query?

Anyone??

 

[Jon K]

You can use a Totals Query to find the max next service due date of each vehicle, and then join the Totals Query back to the data table in a second qeury to pull the records.

I have attached a sample database. You can run the second query in it.
.

 

[ewong1]

Conversion to 97

Can someone convert and repost this access 2000 file as an Access 97 file? Thanks!

 

[Jon K]

Here is an Access 97 version.
.