Search results

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.

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

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.

sorry about that here they are just having a moment I guess.

But with the dummy mbd it is only asking for a parameter for the end date

Here is the dummy version

I am going to make a dummy database with bogus info and post that.

Unfortunately I cannot post it.

Also when I put the dates in when it asks for Parameters it runs the query with the correct information.

I have gone back and forth with this I am just about ready to chuck it and manually right the query every time i need a date range. On my form the text boxes are unbound, does this make a difference?

Thank you all for your input. I have tried the .txt and came up with an error. I have not tried running them as seperate but will try that as well. as for Range v frmRange I was going off of an example I found online that listed the Name such as qryFormQuerySate and in the code it listed...

still not working so I tried to write the query a different way: SELECT [Client Name],[Cause #],[Attorney],[Lead Charge],[Appointed],[Class],[Court] FROM [A and B Felonies] Where ((( [A and B Felonies].Appointed) Between [Forms]![frmRange]![txtStartDate]And [Forms]![frmRange]![txtEndDate]))...

I tried it and when I enter dates on the form then clik the command button it asks for Parameter value for forms!frmRange!txtStartDate and a Parameter value for forms!frmRange!txtEndDAte I am missing something then.

Thank ykou very much. I will try it.

I am currently using Access 2003, I have created a very simple database. I am trying to create a form that will run a date range. So far, I have been abble to accomplish this. I created the form with the name Range. Next I created a query. The date filed that I am searching for is title...