Converting a date to length of time

[Duncan]

I’m creating a database for work and in the initial client table I have dates of when the company/person became a client. Using these dates (or via other methods?) is there a way to calculate in days or months and days, the length of time they have been a client within the table or within a query. Using Access 2007.

[Rixxe]

To calculate the difference between 2 dates, so client registration to now?
I would use Datediff in a query:

selectDATEDIFF(day, registration, 10/11/2010)

That should give you the difference in days, but you can change it from days to months etc.
Note: you might have to use 'dd' instead of 'day'

Hope thats what you wanted.

Good luck


Rixxe

[Duncan]

Many thanks will give it a go