Search results

Thanks Ranman, It's not working though. I've tried a few variations: SELECT Sum [DATE REQUEST RECEIVED] FROM Tbl_NPPR_LOG WHERE (date) Between #1/1/2016# And #1/2/2016# This gives me a syntax error SELECT Sum (Date) FROM Tbl_NPPR_LOG WHERE [DATE REQUEST RECEIVED] Between #1/1/2016# And...

Hi Guys, I'm building a database, and I'm nearly finished. I only have one thing left to do, but I'm working on 16 year old knowledge and missing a few bits. I have a table that has the field [Date Received]. Is there a way to do a query that sums up the total records that fall between two...

Hi Guys, I have the below code to send an e-mail. It's not a million miles away from the excel equivalent. I'm looking to have a button on a Form to e-mail confirmation e-mails once something has been completed. I would like to know if there is a way to insert a for field into the e-mail...