Calculating incidents when a value is >3

[Weresmytriple]

Hi I'm creating a simple delivery management database. I have created a query that calculates the time taken to deliver a package. However I need it to work out how many times it took longer than 3 days and just display the amount of times that this occurred. I'm using access 2003. Thanks for any help

Michael

 

[CJ_London]

It would help if you explained your table structure! but assuming you have two dates - a despatch date and a receipt date - in the same record then your query would be along the following lines

SELECT * FROM myTable WHERE datediff("d",DespatchDate,RecieptDate)>3

 

[namliam]

Include into your query something along the lines of:
Where Date() - [YourDeliveryDate] >3

Offcourse this will work on calander dates and does not take saturdays/sundays/bankholidays etc into account

 

[pr2-eugin]

Weresmytriple, Without seeing how your data is stored in the table (Or) without seeing how you get the records that are delivered after 3 days.It is quiet hard to give a accurate answer.

EDIT: This is just amusing..
CJ_London - 11:11 AM
namliam - 11:12 AM
pr2-eugin - 11:13 AM

 

[Weresmytriple]

Thanks for the help. I would have included more details however I am currently on my phone as my office currently hasn't got Internet. So I didn't want to over complicate the typing. Thanks for the help guys I have sorted it now