Date Parameters are not working.

[grantsd]

Hey all,

I'm working on an applied time report. I'm using a slightly modified version of the Service Call Management template that comes with Access.

What I'm trying to achieve is a report that will display the BillableHours by Employee for the date range entered.

I copied the code of one report to get the date range information - it now asks for date range, etc, and the report populates from my sources, yet it doesn't follow the date range. IE, if I put something in today for hours, and then run a report for last month, the hours I entered in today still display.

I'm a newbie in Access, but I pick things up quickly if someone has the time to kinda walk me through it!

Thanks for any help or input!

Scott

 

[oldaf294]

queries

grant,
again, try a query.
Follow the "new" query method selecting all the fields you need for the report.
In the criteria section of the query grid under your "Datefield" type;
Between [Startdate] and [Enddate]
(Or any text you want between the braces)
Run the query and enter the dates. It should list all instances of your data.
Use this query for your report.
jim

 

[grantsd]

Just got back into work. Trying the query method (told you I was a newbie) and will let you know! Thanks for the input!

 

[grantsd]

Does the fact that I'm using a form to input the Before/After Dates matter? By the way, I'm using access 2000. The Wizard doesn't have any spot for entering criteria, I'm assuming design view does somewhere!

Thanks,

Scott

 

[oldaf294]

paramaters

scott,
if you put the "Between....." in the criteria section of the query grid of your date field and your form is based on the query, a parameter box should appear when you open the form prompting for the "start date" and "end date"
jim

 

[grantsd]

Is this in design view?

Basically, I'm using the Service Call Management template from Access 2000. I've edited quite a few things, but the reports are the same basically. If you have the chance to look at that template, you'll see they use a form for all date-related reports that allows a Start/End Date entry. That form is then applied to reports.

I copied one of the other reports that uses it and changed what I needed to get the results. I actually have the desired information, and it does ask for dates, but it doesn't filter them BY the dates. Thus, if I enter information on 10/10/2004, and I put 10/10/2000 through 10/11/2000 in my criteria, it will still return EVERYTHING in the database.

Hope that helps. And yes, I'm a newbie.

 

[oldaf294]

query criteria

grant,
I use accesss97 so I can't see the templates and I am not familiar how the templates work in relation to a report.
Did you try using a query and base the report on it?
The only other suggestion i have would be to try to disect the template to see where and how the criteria is determined.

 

[grantsd]

Thanks tons!

I got it working, I was a total moron, heh. Thanks for all the help and patience.

 

[oldaf294]

questions

There are no dumb questions if you don't know the answer!!!
Thats what these forums are for. Glad you made it work. jim