Report and subreport w/Criteria Parameters issues

[Skrogy]

Report with criteria parameters issues.
I have a table includes startdate-starttime-enddate-starttime
startingmiles-endingmiles
I have created a query including all and adding Hours:
DateDiff("h",[StartDate]+[Startime],[enddate]+[endtime]) for one column then
Miles: ([endingmiles]-[startingmiles]) for the other. To get a total for each
of the days. I then created a report for this query.
I then created another query for a grand total using Total Miles:
sum([Miles]) for one then Total Hours: sum([Hours]) then Milage Pay:
CCur([total miles]*0.585) then Hours Pay: CCur([Total Hours]*13) then Total
Pay: CCur([Hours Pay]+[Milage Pay]) for the last one. I created a report
based on that info only.
Using the second report as a subreport to the first report it works great!
However I want to use criteria parameter for start dates so I use >=[Start
date] under my first query under startdate and run my report with the
subreport on it and I will the requested criteria parameter however I will be
asked 2 times. If I put info in twice I get the result I want. Is this a
normal response for this type of report/subreport/ with criteria parameters?

 

[KARL DEWEY]

Use an unbound form with unbound textboxes for entry.
NOTE - The form must be open and data in the textboxes.

Refer to the textboxes in the queries like this --
[Forms]![YourFormName]![TextBoxName]
Or
Like "*" & [Forms]![YourFormName]![TextBoxName] & "*"

 

[Skrogy]

Thanks for your reply!
However I want the form to be bound as I am basically creating a time card
millage database then calculating an hourly rate along with milage. So it
will not do me any good to make a form to just make a form to type in data
and not save it.
Again thanks for your reply and suggestion

Use an unbound form with unbound textboxes for entry.
NOTE - The form must be open and data in the textboxes.

Refer to the textboxes in the queries like this --
[Forms]![YourFormName]![TextBoxName]
Or
Like "*" & [Forms]![YourFormName]![TextBoxName] & "*"

--
KARL DEWEY
Build a little - Test a little

Report with criteria parameters issues.
I have a table includes startdate-starttime-enddate-starttime
startingmiles-endingmiles
I have created a query including all and adding Hours:
DateDiff("h",[StartDate]+[Startime],[enddate]+[endtime]) for one column then
Miles: ([endingmiles]-[startingmiles]) for the other. To get a total for each
of the days. I then created a report for this query.
I then created another query for a grand total using Total Miles:
sum([Miles]) for one then Total Hours: sum([Hours]) then Milage Pay:
CCur([total miles]*0.585) then Hours Pay: CCur([Total Hours]*13) then Total
Pay: CCur([Hours Pay]+[Milage Pay]) for the last one. I created a report
based on that info only.
Using the second report as a subreport to the first report it works great!
However I want to use criteria parameter for start dates so I use >=[Start
date] under my first query under startdate and run my report with the
subreport on it and I will the requested criteria parameter however I will be
asked 2 times. If I put info in twice I get the result I want. Is this a
normal response for this type of report/subreport/ with criteria parameters?