How to run two queries with one entry

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have two reports I need to run, one for docking and one for departing.
Each report uses the same dates. Now how can I create one report that
requires the date only entered once but will display both query information?

Thanks Jen
 
Dear Jen:

If possible, use one form that is the place from which both reports are
initiated. Put controls on it in which the user enters the dates. Write
the queries for the reports so they reference those controls to retrieve the
values from the form.

A Jet query can reference the value in any control on any open form. Use
this syntax:

[Forms]![Form Name]![Control Name]

Replace Form Name and Control Name with the actual name of the form and
controls required.

Tom Ellison
 
Tom, I think that is a little above my head. I have one table that stores
this information but two colums. I need to run one report using the one
table but with two different breakdowns.

I produced a dummy report and inserted sub-reports but I have to enter the
search information twice and then when I attempt to print it request that
same information again.


Tom Ellison said:
Dear Jen:

If possible, use one form that is the place from which both reports are
initiated. Put controls on it in which the user enters the dates. Write
the queries for the reports so they reference those controls to retrieve the
values from the form.

A Jet query can reference the value in any control on any open form. Use
this syntax:

[Forms]![Form Name]![Control Name]

Replace Form Name and Control Name with the actual name of the form and
controls required.

Tom Ellison


Jen said:
I have two reports I need to run, one for docking and one for departing.
Each report uses the same dates. Now how can I create one report that
requires the date only entered once but will display both query
information?

Thanks Jen
Click to expand...
Click to expand...
 
Dear Jen:

What I suggested is pretty simple. Could you tell me what seemd "over your
head" in it. I'd be glad to try to explain in some detail if I knew what it
is that is troubling you.

Tom Ellison


Jen said:
Tom, I think that is a little above my head. I have one table that stores
this information but two colums. I need to run one report using the one
table but with two different breakdowns.

I produced a dummy report and inserted sub-reports but I have to enter the
search information twice and then when I attempt to print it request that
same information again.


Tom Ellison said:
Dear Jen:

If possible, use one form that is the place from which both reports are
initiated. Put controls on it in which the user enters the dates. Write
the queries for the reports so they reference those controls to retrieve
the
values from the form.

A Jet query can reference the value in any control on any open form. Use
this syntax:

[Forms]![Form Name]![Control Name]

Replace Form Name and Control Name with the actual name of the form and
controls required.

Tom Ellison


Jen said:
I have two reports I need to run, one for docking and one for departing.
Each report uses the same dates. Now how can I create one report that
requires the date only entered once but will display both query
information?

Thanks Jen
Click to expand...
Click to expand...
Click to expand...
 
Okay Tom,

I tried the FrmWhatdates and it didn't work.
In the column for

StartTime I need to specify from 04/26/06 00:01 to 04/26/06 23:59 this will
generate my first report (did that)

EndTime I need to specify from 04/26/06 00:01 to 04/26/06 23:59 this will
generate my second report (did that)

result didn't work......

Can you recommend a good website to figure this out?????

Tom Ellison said:
Dear Jen:

What I suggested is pretty simple. Could you tell me what seemd "over your
head" in it. I'd be glad to try to explain in some detail if I knew what it
is that is troubling you.

Tom Ellison


Jen said:
Tom, I think that is a little above my head. I have one table that stores
this information but two colums. I need to run one report using the one
table but with two different breakdowns.

I produced a dummy report and inserted sub-reports but I have to enter the
search information twice and then when I attempt to print it request that
same information again.


Tom Ellison said:
Dear Jen:

If possible, use one form that is the place from which both reports are
initiated. Put controls on it in which the user enters the dates. Write
the queries for the reports so they reference those controls to retrieve
the
values from the form.

A Jet query can reference the value in any control on any open form. Use
this syntax:

[Forms]![Form Name]![Control Name]

Replace Form Name and Control Name with the actual name of the form and
controls required.

Tom Ellison


I have two reports I need to run, one for docking and one for departing.
Each report uses the same dates. Now how can I create one report that
requires the date only entered once but will display both query
information?

Thanks Jen
Click to expand...
Click to expand...
Click to expand...
 
Dear Jen:

From what you posted, your "StartTime" is a range, for example from 4/26/06
00:01 to 4/26/06 23:59. Somehow that does not seem like a single date/time
value at all. This would take two controls to enter two date/time values.
Did you create two controls? What are their names? What is the name of the
form on which they appear? What is the SQL you wrote to reference these?

Same thing for EndTime.

Tom Ellison


Jen said:
Okay Tom,

I tried the FrmWhatdates and it didn't work.
In the column for

StartTime I need to specify from 04/26/06 00:01 to 04/26/06 23:59 this
will
generate my first report (did that)

EndTime I need to specify from 04/26/06 00:01 to 04/26/06 23:59 this will
generate my second report (did that)

result didn't work......

Can you recommend a good website to figure this out?????

Tom Ellison said:
Dear Jen:

What I suggested is pretty simple. Could you tell me what seemd "over
your
head" in it. I'd be glad to try to explain in some detail if I knew what
it
is that is troubling you.

Tom Ellison


Jen said:
Tom, I think that is a little above my head. I have one table that
stores
this information but two colums. I need to run one report using the
one
table but with two different breakdowns.

I produced a dummy report and inserted sub-reports but I have to enter
the
search information twice and then when I attempt to print it request
that
same information again.


:

Dear Jen:

If possible, use one form that is the place from which both reports
are
initiated. Put controls on it in which the user enters the dates.
Write
the queries for the reports so they reference those controls to
retrieve
the
values from the form.

A Jet query can reference the value in any control on any open form.
Use
this syntax:

[Forms]![Form Name]![Control Name]

Replace Form Name and Control Name with the actual name of the form
and
controls required.

Tom Ellison


I have two reports I need to run, one for docking and one for
departing.
Each report uses the same dates. Now how can I create one report
that
requires the date only entered once but will display both query
information?

Thanks Jen
Click to expand...
Click to expand...
Click to expand...
 
Back
Top