Query multiple fields

[Stemdriller]

Hi all

I have been given the task to convert an old Lotus Database into Access 2010.

My main issue is all the data is on one record, so all customer data and service data.

The service data has 6 fields all with dates in, what I am trying to achieve is a query that will bring back the latest date from these fields as then I can get a grip as to when the next services are due, eg add 365 days to the result etc etc.

I believe it probably is the MAX command but I just cannot get the syntax right.

Any help?

Thanks

Gareth

 

[jdraw]

Everything in 1 record???
Where is the data now? How did you get it from Lotus?
Can you tell us more about

The service data has 6 fields all with dates in

?

 

[Stemdriller]

I exported the data to Excel, then simply imported into Access creating a Primary key.

I only need to query this old legacy data, a new table has been created for any new service info. It's for a Central Heating firm, keeping records for boiler services.

Attached is a snapshot.

Hope u can help

GW