Combining multiple queries in one in Access

Posted by Arlen Beiler on Stack Overflow See other posts from Stack Overflow or by Arlen Beiler
Published on 2013-07-03T17:02:16Z Indexed on 2013/07/03 17:05 UTC
Read the original article Hit count: 200

Filed under:

ms-access-2003

I have two queries that I want to combine into one in Microsoft Access 2003.

SELECT AttendanceQuery.AttendDate, Count(*) AS Absent
FROM AttendanceQuery
WHERE (((AttendanceQuery.Present)=False))
GROUP BY AttendanceQuery.AttendDate;

SELECT AttendanceQuery.AttendDate, Count(*) AS Enrollment
FROM AttendanceQuery
GROUP BY AttendanceQuery.AttendDate;

The one shows the total records for each date, the other shows the ones that are marked absent.

Related posts about ms-access-2003

MS Access 2003 - Embedded Excel Spreadsheet on Access form

as seen on Stack Overflow - Search for 'Stack Overflow'
lets say I have an embedded Excel Spreadsheet on a Microsoft Access form. I call the object frame ExcelFrame and I add a text box on the form called txtA1 and I add a button on the form called cmdInsert I want to type "Hello World" into the text box, click the button and have it appear in… >>> More
MS Access 2003 - ordering the string values for a chart not alphabetical

as seen on Stack Overflow - Search for 'Stack Overflow'
Here is a silly question. Lets say I have a query that produces for a list box, and it produces values for three stores Store A 18 Store B 32 Store C 54 Now if I ORDER BY in the sql statement the only thing it will do is descending or ascending alphabetically but I want a certain order… >>> More
MS Access 2003 - Message Box: How can I answer "ok" automatically through code

as seen on Stack Overflow - Search for 'Stack Overflow'
So a couple silly questions: If I include this in some event: MsgBox " ", vbOkOnly, "This little message box" could I then with some more code turn around and 'click the ok button. So that basically the message boox automatically pops up, and then automatically goes away? I know its silly because… >>> More
MS Access 2003 - Format a Number with Commas AND Auto-Decimal

as seen on Super User - Search for 'Super User'
On a report I have a control which is bound to a column which can have up to 3 decimal places. I want the number to format with commas separating thousands and millions, but I also want the number of decimal places to be automatic, so that if there is no decimal portion then no decimal at all is… >>> More
MS Access 2003 - VBA for altering a table after a "SELECT * INTO tblTemp FROM tblMain" statement

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi. I use functions like the following to make temporary tables out of crosstabs queries. Function SQL_Tester() Dim sql As String If DCount("*", "MSysObjects", "[Name]='tblTemp'") Then DoCmd.DeleteObject acTable, "tblTemp" End If sql = "SELECT * INTO tblTemp from TblMain;" Debug.Print (sql) … >>> More

Developer IT

Combining multiple queries in one in Access - Developer IT

Combining multiple queries in one in Access

ms-access-2003

Related posts about ms-access-2003

MS Access 2003 - Embedded Excel Spreadsheet on Access form

MS Access 2003 - ordering the string values for a chart not alphabetical

MS Access 2003 - Message Box: How can I answer "ok" automatically through code

MS Access 2003 - Format a Number with Commas AND Auto-Decimal

MS Access 2003 - VBA for altering a table after a "SELECT * INTO tblTemp FROM tblMain" statement

Categories cloud