I need to breakdown the two subqueries by File_Date. Now it’s just giving me the total number of records per Service_Code. SELECT [Request File].File_Date, Count([Request File].SSN) AS [Borrower Count], Sum([Request File].Discharge_Amt) AS Total_Discharge_Amt, (SELECT Count([Request File].SSN) FROM [Request File] WHERE [Request File].Servicer_Code="500") AS 500_Count, (SELECT Count([Request File].SSN) FROM [Request File] WHERE [Request File].Servicer_Code="579") AS 579_Count… Read More Subquery Totals in Access

I have a login form. I have a username and password text box with a login and close button. I would like: Text saying "username" in the username and "password" in the pass field. When clicked on the text disappears. If clicked on and you focus on something else without typing anything, it will return… Read More Microsoft Access – Placeholder in Textbox VBA