Matching date range in subreports

[Anne]

I have a report where I look at work orders completed by a department, I
select the date range when I run the report. I have subreports that
summarize each employee in the department. How do I link the date range I
select in the main report so that the subreports are run for the same date
range? I tried using the DatePerformed field in the main report as the
control source for the DatePerformed field in the subreports but it did not
work.

 

[KARL DEWEY]

Use an unbound form with unbound text boxes to enter date ranges.
In query for reports use criteria --
Between [Forms]![YourFormName]![Box1] And [Forms]![YourFormName]![Box2]

 

[Anne]

Thanks Karl,

My subreports are unbound. I'm confused about the instruction about an
unbound form and unbound text box with date ranges as I'm work on reports. I
tried putting the "Between.." text line in the DatePerformed field in my
subreport query but that didn't work the subreport didn't show at all in the
main report.

--
Anne

Use an unbound form with unbound text boxes to enter date ranges.
In query for reports use criteria --
Between [Forms]![YourFormName]![Box1] And [Forms]![YourFormName]![Box2]
--
KARL DEWEY
Build a little - Test a little

I have a report where I look at work orders completed by a department, I
select the date range when I run the report. I have subreports that
summarize each employee in the department. How do I link the date range I
select in the main report so that the subreports are run for the same date
range? I tried using the DatePerformed field in the main report as the
control source for the DatePerformed field in the subreports but it did not
work.

 

[KARL DEWEY]

My subreports are unbound.
Where does the data come from if unbound? But then you say "...in my
subreport query ..."

What are you using for Master/Child links between the report/subreport?

What method do you use to "...select the date range ..." when you run the
report?

--
KARL DEWEY
Build a little - Test a little

Thanks Karl,

My subreports are unbound. I'm confused about the instruction about an
unbound form and unbound text box with date ranges as I'm work on reports. I
tried putting the "Between.." text line in the DatePerformed field in my
subreport query but that didn't work the subreport didn't show at all in the
main report.

--
Anne

Use an unbound form with unbound text boxes to enter date ranges.
In query for reports use criteria --
Between [Forms]![YourFormName]![Box1] And [Forms]![YourFormName]![Box2]
--
KARL DEWEY
Build a little - Test a little

I have a report where I look at work orders completed by a department, I
select the date range when I run the report. I have subreports that
summarize each employee in the department. How do I link the date range I
select in the main report so that the subreports are run for the same date
range? I tried using the DatePerformed field in the main report as the
control source for the DatePerformed field in the subreports but it did not
work.

 

[Anne]

I have no link between master and child. I select the date range in my query
on my main report "Between [Enter Start Date] and [End Date]". At the moment
I have entered the range in my subreport queries, (the actual dates) and the
report runs fine. I want to be able to use the report for a variety of dates
without going by to my subreport queries each time and manually changing the
date. I want it to refer to the date that I am inputing in the main report.
I hope that makes sense.
--
Anne

Where does the data come from if unbound? But then you say "...in my
subreport query ..."

What are you using for Master/Child links between the report/subreport?

What method do you use to "...select the date range ..." when you run the
report?

--
KARL DEWEY
Build a little - Test a little

Thanks Karl,

My subreports are unbound. I'm confused about the instruction about an
unbound form and unbound text box with date ranges as I'm work on reports. I
tried putting the "Between.." text line in the DatePerformed field in my
subreport query but that didn't work the subreport didn't show at all in the
main report.

--
Anne

Use an unbound form with unbound text boxes to enter date ranges.
In query for reports use criteria --
Between [Forms]![YourFormName]![Box1] And [Forms]![YourFormName]![Box2]
--
KARL DEWEY
Build a little - Test a little


:

I have a report where I look at work orders completed by a department, I
select the date range when I run the report. I have subreports that
summarize each employee in the department. How do I link the date range I
select in the main report so that the subreports are run for the same date
range? I tried using the DatePerformed field in the main report as the
control source for the DatePerformed field in the subreports but it did not
work.

 

[KARL DEWEY]

Ok, back to using the unbound form. Create a form with two text boxes for
entering the start and ending dates. Name the text boxes Box1 and Box2.
Then in both the main form and subform query, under your datefield, in the
criteria row type ---
Between CVDate([Forms]![YourFormName]![Box1]) And
CVDate([Forms]![YourFormName]![Box2])

To run the report you must open the unbound form, enter the dates, and
without closing the form run the report.

I have no link between master and child. I select the date range in my query
on my main report "Between [Enter Start Date] and [End Date]". At the moment
I have entered the range in my subreport queries, (the actual dates) and the
report runs fine. I want to be able to use the report for a variety of dates
without going by to my subreport queries each time and manually changing the
date. I want it to refer to the date that I am inputing in the main report.
I hope that makes sense.
--
Anne

My subreports are unbound.

Where does the data come from if unbound? But then you say "...in my
subreport query ..."

What are you using for Master/Child links between the report/subreport?

What method do you use to "...select the date range ..." when you run the
report?

--
KARL DEWEY
Build a little - Test a little

Thanks Karl,

My subreports are unbound. I'm confused about the instruction about an
unbound form and unbound text box with date ranges as I'm work on reports. I
tried putting the "Between.." text line in the DatePerformed field in my
subreport query but that didn't work the subreport didn't show at all in the
main report.

--
Anne


:

Use an unbound form with unbound text boxes to enter date ranges.
In query for reports use criteria --
Between [Forms]![YourFormName]![Box1] And [Forms]![YourFormName]![Box2]
--
KARL DEWEY
Build a little - Test a little


:

I have a report where I look at work orders completed by a department, I
select the date range when I run the report. I have subreports that
summarize each employee in the department. How do I link the date range I
select in the main report so that the subreports are run for the same date
range? I tried using the DatePerformed field in the main report as the
control source for the DatePerformed field in the subreports but it did not
work.

 

[Anne]

Thanks Karl,

For some reason I couldn't get on to this website so a few days but I kept
plugging away and with your suggestion and some other posts I had read I got
there. I had a problem making an unbound form but eventually made one and
then removed the control source. Probably not the way to go about it but it
worked! My report is up and running like a charm now. Thanks
--
Anne

Ok, back to using the unbound form. Create a form with two text boxes for
entering the start and ending dates. Name the text boxes Box1 and Box2.
Then in both the main form and subform query, under your datefield, in the
criteria row type ---
Between CVDate([Forms]![YourFormName]![Box1]) And
CVDate([Forms]![YourFormName]![Box2])

To run the report you must open the unbound form, enter the dates, and
without closing the form run the report.

I have no link between master and child. I select the date range in my query
on my main report "Between [Enter Start Date] and [End Date]". At the moment
I have entered the range in my subreport queries, (the actual dates) and the
report runs fine. I want to be able to use the report for a variety of dates
without going by to my subreport queries each time and manually changing the
date. I want it to refer to the date that I am inputing in the main report.
I hope that makes sense.
--
Anne

My subreports are unbound.
Where does the data come from if unbound? But then you say "...in my
subreport query ..."

What are you using for Master/Child links between the report/subreport?

What method do you use to "...select the date range ..." when you run the
report?

--
KARL DEWEY
Build a little - Test a little


:

Thanks Karl,

My subreports are unbound. I'm confused about the instruction about an
unbound form and unbound text box with date ranges as I'm work on reports. I
tried putting the "Between.." text line in the DatePerformed field in my
subreport query but that didn't work the subreport didn't show at all in the
main report.

--
Anne


:

Use an unbound form with unbound text boxes to enter date ranges.
In query for reports use criteria --
Between [Forms]![YourFormName]![Box1] And [Forms]![YourFormName]![Box2]
--
KARL DEWEY
Build a little - Test a little


:

I have a report where I look at work orders completed by a department, I
select the date range when I run the report. I have subreports that
summarize each employee in the department. How do I link the date range I
select in the main report so that the subreports are run for the same date
range? I tried using the DatePerformed field in the main report as the
control source for the DatePerformed field in the subreports but it did not
work.

 

[brittney]

kevinliviston

Thanks Karl,

For some reason I couldn't get on to this website so a few days but I
kept
plugging away and with your suggestion and some other posts I had read I
got
there. I had a problem making an unbound form but eventually made one and
then removed the control source. Probably not the way to go about it but
it
worked! My report is up and running like a charm now. Thanks
--
Anne

Ok, back to using the unbound form. Create a form with two text boxes
for
entering the start and ending dates. Name the text boxes Box1 and Box2.
Then in both the main form and subform query, under your datefield, in
the
criteria row type ---
Between CVDate([Forms]![YourFormName]![Box1]) And
CVDate([Forms]![YourFormName]![Box2])

To run the report you must open the unbound form, enter the dates, and
without closing the form run the report.

I have no link between master and child. I select the date range in my
query
on my main report "Between [Enter Start Date] and [End Date]". At the
moment
I have entered the range in my subreport queries, (the actual dates)
and the
report runs fine. I want to be able to use the report for a variety of
dates
without going by to my subreport queries each time and manually
changing the
date. I want it to refer to the date that I am inputing in the main
report.
I hope that makes sense.
--
Anne


:

My subreports are unbound.
Where does the data come from if unbound? But then you say "...in my
subreport query ..."

What are you using for Master/Child links between the
report/subreport?

What method do you use to "...select the date range ..." when you run
the
report?

--
KARL DEWEY
Build a little - Test a little


:

Thanks Karl,

My subreports are unbound. I'm confused about the instruction about
an
unbound form and unbound text box with date ranges as I'm work on
reports. I
tried putting the "Between.." text line in the DatePerformed field
in my
subreport query but that didn't work the subreport didn't show at
all in the
main report.

--
Anne


:

Use an unbound form with unbound text boxes to enter date ranges.
In query for reports use criteria --
Between [Forms]![YourFormName]![Box1] And
[Forms]![YourFormName]![Box2]
--
KARL DEWEY
Build a little - Test a little


:

I have a report where I look at work orders completed by a
department, I
select the date range when I run the report. I have subreports
that
summarize each employee in the department. How do I link the
date range I
select in the main report so that the subreports are run for
the same date
range? I tried using the DatePerformed field in the main
report as the
control source for the DatePerformed field in the subreports
but it did not
work.