Jul 21 2011, 05:34 PM
I have a problem related to this so I figured I'd ask here before posting a new question. I have the Between ([What is the start date?] AND [What is the end date?] and it works just fine on all of my reports except for one. I've tried deleting it and redoing the report and even deleted and recreated the query it is run from but no luck. It shows all the dates when it should only be showing for the 1st quarter for this year (1/1/11 through 3/31/11). I'm thinking it may be because I am pulling multiple data boxes into the report? Anyone else have this problem and what did you do to fix it? Please help!
Jul 21 2011, 11:42 PM
What version of Access are you using? Sorry, I had to move your question to a new topic because it really doesn't have anything to do with this topic
Jul 27 2011, 10:15 AM
Hi. Thank you. I have Access 2000 at work and this is where I'm having this problem. It's frustrating me like crazy! Help!
Jul 27 2011, 10:33 AM
You might consider posting a zip copy of your db with test data.
Just my 2 cents...
Jul 27 2011, 10:36 AM
Are you using a Crosstab Query for this Report? And if so, did you enter all these "extra" months in the Column Headings of the Property Sheet for the Crosstab Query?
Jul 27 2011, 11:51 AM
Have you tried setting those parameters in the SQL as dates (as in right clicking on the query grid and selecting 'parameters' and expressing their data type there. Is the data you are pulling all in the correct data format? try putting Cdate() around the date fields and see if it comes up with any errors.
Jul 27 2011, 01:00 PM
I'll have to take out the patient identifying factors out first such as medical record ID before I can zip and post it on here, due to HIPAA regulations. I'll try posting it up later today.
I am using a crosstab query and it is set up exactly like the other reports I have. I have double checked and found no errors in comparison to my other reports. The only thing I am finding is the number of columns I am using is more than the others. Is there a limit as to how much information can be in a single report? The formula I am using is "Between ([What is the start date?]) AND [What is the end date?]" It works for all the others but not this one. I will try out what JonSmith suggested and let you know if it works. I am not an advanced user so if I am doing things wrong with the date please help. :-) Thank you everyone for your help.
Jul 27 2011, 01:35 PM
Good luck and let us know how you get on.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here