How to get average number of days between two databases

[joe789]

Hi Folks,

I have two databases. One database shows a unique identifier per person and a unique date for that person -- the unique identifier (person) can have more than one unique date. The other database shows a unique identifier per person and a unique date for that person -- the unique identifier (person) can have more than one unique date.

Is it possible to create a query where by I can determine the average number of days between the two databases per unique person and as a whole database. I am trying to determine the number of days between database1 and the very next date in database2. I am not sure this is even possible

Any help would be greatly appreciated.

Thank you very much,

Joe

 

[dcx693]

Are you confused about how to get to the data in the other database? Just link the 2nd database table to the first database.

Calculating the average number of days between databases for unique persons amounts to setting up queries. The tricky-sounding part is where you say the unique identifier (person) can have more than one unique date. Can you post a sample of the data in the two databases?

To calculate the average number of days for the whole database, do a totals query, using the Avg function.

It all sounds possible, we just need some more info about the data so we can point you in the right direction.