Recent content by lafrazia

That's correct. I need the sum of gross from 12/4/20 thru 12/4/21 for this once instance and in others I will have different dates that I would like to enter total gross for the period entered.

This Field is numeric

This is the sql. The data it returns is accurate. Just looking to simplify so that when running for other individuals the date we need to do a 52 week lookback for a total gross can be done thru a prompt for the specific date. SELECT pay_check.emplid, employees.first_name...

Thank you, but unfortunately its returning all data going back to 2015.

Hello everyone. I'm having a problem with a date criteria. I'm creating a query that returns one year of data from a specific date entered thru a prompt. This seems to work - >=#12/4/2021#-365 And <=#12/4/2021#. The issue is that the date will constantly change and I want to be able to enter...