Run a query between date ranges using SQL

[boblarson]

Okay, here's the sample revised. You should be able to copy the union query to your real db. You would need to relink the Excel spreadsheets in the sample to get the sample to run.

 

[PALPETE]

Thank you it is working now. So, I must have been using and older syntax that when I orginally wrote the SQL it called for () in order for it to work.

A big Thank you for all of your inputs.

 

[boblarson]

You also had forgotten to change frmRange in the part for the End Date to just Range. That is why the start date didn't give a prompt but the End Date did.

 

[PALPETE]

I guess I just looked at it so much it was all running together.

 

[boblarson]

I guess I just looked at it so much it was all running together.

I know the feeling. Plus, as you found out - it took a very short time to fix it once I was able to actually see it and test it. I am way more "visual" when it comes to things like that. If I can see it, I am much better off then trying to do the questioning path.

 

[PALPETE]

I am the visual type myself so I can completely understand. I do not know why I didn't think about making the dummy db earlier.

 

[wazz]

Wazz:
You can't use .Text unless the control has focus...

oops. sry palpete for the diversion. for some reason i get hung up on using '.Text'. glad it's working.