Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by INKEYPR
-
Calculating the number of days between orders
Hi PHV, Thank you for your clarification. I get it now. Everything works great. Take Care,- INKEYPR
- Post #5
- Forum: Microsoft: Access Queries and JET SQL
-
Calculating the number of days between orders
Hi dhookom. I appreciate your quick response. Even with the great expression, I am still getting results that calculates the min([OrderDate]) from the max([OrderDate])-Refer to my first email on the record that calculated the diff of 181 days. This is OK if I have only two order dates, but is...- INKEYPR
- Post #4
- Forum: Microsoft: Access Queries and JET SQL
-
Calculating the number of days between orders
Question: In my Access table ORDERS, I have two objects, [CustomerID] and [OrderDate]. Each customer has many order dates and I am interested in doing analysis to determine the actual number of days between orders. I am looking for a solution that I can do in the QBE grid and would consider a...- INKEYPR
- Thread
- Replies: 4
- Forum: Microsoft: Access Queries and JET SQL
