Search results

Thanks everyone for your help.. unfortunately I have patient information so i am unable to share my database or query.. I will just run a query and update it monthly to run between #date# and #date#. Thank you.

this did not pull any data.

"Data type mismatch in criteria expression."

I have.. .but i am wanting the whole month, not just the first and last day of the month.

Why does it work for my first query then to pull the current month if those same spots don't have due dates?

This is a small section of my database, every person has a section like this that I pull from. Tasks Labs Diagnosis Reoccurence Next Due Date TSH/FT4/Lipid Hypothyroid/Hyperlipodemia q 3 month 03/04/2020 Valproic/CBC/AST/ALT HRM q 6 months 06/23/2020 Glucose/Amylase HRM Annual...

I am still getting that error.

When i tried that it says "Data type mismatch in criteria expression."

None of these have worked.... here is what i have to pull the current month, Between DateSerial(DatePart("yyyy",Date()),DatePart("m",Date()),1) And DateAdd("d",-1,DateAdd("m",1,DateSerial(DatePart("yyyy",Date()),DatePart("m",Date()),1))) i figured it would be easy to change it to pull the next...

I am needing to pull data for what's due next month. I don't want to have to update it every month, just want it to do it automatically. So today is 2/21/2020, i want it to show 3/1/20 to 3/31/20..