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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Compliance Report
I figured out myself the next step I Used SELECT TOP 1 ........... Thanks everyone for sharing your knowledge. I certainly learned a lot about UNION queries, which I had no idea what they were for.- cocoaice
- Post #6
- Forum: Microsoft: Access Queries and JET SQL
-
Compliance Report
I went over Golom's idea. This is my current SQL Select (Select Count(*) From qry_Data Where HOB30 = 'Yes' AND Date BETWEEN [StartDate] AND [EndDate] ) As Q1Yes, (Select Count(*) From qry_Data Where HOB30 IN ('Yes','No')AND Date BETWEEN [StartDate] AND [EndDate]) As Q1YesNo, Format...- cocoaice
- Post #5
- Forum: Microsoft: Access Queries and JET SQL
-
Compliance Report
I have a table with a date field and five different questions that can only be answered as "Yes", "No", "N/A". I am trying to run a report that calculates compliance for each question at a determined date range parameter. TblData([dtmReportDate],[strQ1],[strQ2],[strQ3],[strQ4],[strQ5]) I...- cocoaice
- Thread
- Replies: 5
- Forum: Microsoft: Access Queries and JET SQL
