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 Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: Sylvia589943
- Order by date
-
Display results as quarterly lists
Thank you - we need to know the last date for each test for each patient - eg: last echo; last ECG; last angiogram - etc for each patient not just the latest test date overall - does that make sense??- Sylvia589943
- Post #5
- Forum: Microsoft: Access Queries and JET SQL
-
Display results as quarterly lists
The Table shows:- TestID (autonumber) PatientNo: ECG Angiogram Echo LVSD With the exception of the PatientNo: field, the remainder are dates. I have a query using "maxof.." to give me the latest date for each test for each patient (is this the best way to do this??) We would like the Report...- Sylvia589943
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
Display results as quarterly lists
I have an Access Database and need to display results as quarterly lists on one report - e.g.: Last 3 months 6 months 9 month 12 months Jim John Sam Richard Lilly Robert Jenny Bill Judy I'm not sure if I would do this at the...- Sylvia589943
- Thread
- Replies: 6
- Forum: Microsoft: Access Queries and JET SQL
