display query data on report

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

Guest

Im having trouble displaying the query data on my reports.
I have figured out how to display one set of the data, that was 'site name',
however when trying to display the start/finish dates of the query I cant
find it the same way using the control source function.

I think the problem is that I have used a create table query first then
completed a cross tab query to create the reports. Changing the date formats
from 01-Nov-05 in the first query into either months or weeks depending on
the report.

Thanks for the help in advance
 
If I am reading this correctly, you use a query with some
parameter(s) to create a table, from which you run a
crosstab query, which you use for a report, now you wish
the report to reflect the paramerters used in the make-
table query.
The best way to accomplish this would be to start with
creating a form with unbound textbox(es) where you would
enter your parameter(s), than while keeping this form
open, use these parameter(s) in your make-table query,and
run the crosstab query and ultimately the report.
Hope this helps.
Fons
 
Bugger

Im well on the way to finishing this and would hate to even think about
starting again, will look into it though, cheers
 
Would this be a possibility at all??? adding an unbound text box to the form
and then adding info in the control source along the lines of below;

Between [Type the first start date range] AND [Type the second start date
range]

="ddd" & [Type the first start date range] & "ddd" & [Type the second start
date range]

I know none of the above work but hopefully another one does.

Cheers for the help
 
You would crate a form name it "YourForm" with two unbound
textboxes.
In the label of the first textbox you would
enter "between" without quotes, than in the first textbox
you would enter "=[Enter Start Date]" and name this
textbox "Start", the second label would be "and" and the
second textbox would be "=[End Date]", name this
textbox "End"
All of these omit the " quotes.
now in your make table query in the criteria for the date
you would enter "Between forms.YourForm.Start and
forms.YourFom.End "
Again omit the " quotes.
You can now create a macro to run the make table query and
the crosstab query and than print the report, one after
the other. And on the form make one button to run this
macro.
All done.
Fons
 
half way there....

in the text box i have #Name? not sure why??
control source is =[Enter Start Date]
name is Start

the criteria for the query reads;
Between [forms].[YourForm].[Start] And [forms].[YourForm].[end]

does not seem to do it
thanks for the help

Fons Ponsioen said:
You would crate a form name it "YourForm" with two unbound
textboxes.
In the label of the first textbox you would
enter "between" without quotes, than in the first textbox
you would enter "=[Enter Start Date]" and name this
textbox "Start", the second label would be "and" and the
second textbox would be "=[End Date]", name this
textbox "End"
All of these omit the " quotes.
now in your make table query in the criteria for the date
you would enter "Between forms.YourForm.Start and
forms.YourFom.End "
Again omit the " quotes.
You can now create a macro to run the make table query and
the crosstab query and than print the report, one after
the other. And on the form make one button to run this
macro.
All done.
Fons
-----Original Message-----
Bugger

Im well on the way to finishing this and would hate to even think about
starting again, will look into it though, cheers


.
Click to expand...
Click to expand...
 
Pete. I don't know what you named the form whaere you
have your parameters. Make sure you substitute that form
name for "YourForm" in the formula, also make sure the
anmes of the two textboxes for the start and end date are
the same as in the formula. If needed send me a message
at my email fonsponsio at ISP sbcglobal.net.
Fons
-----Original Message-----
half way there....

in the text box i have #Name? not sure why??
control source is =[Enter Start Date]
name is Start

the criteria for the query reads;
Between [forms].[YourForm].[Start] And [forms].[YourForm]. [end]

does not seem to do it
thanks for the help

Fons Ponsioen said:
You would crate a form name it "YourForm" with two unbound
textboxes.
In the label of the first textbox you would
enter "between" without quotes, than in the first textbox
you would enter "=[Enter Start Date]" and name this
textbox "Start", the second label would be "and" and the
second textbox would be "=[End Date]", name this
textbox "End"
All of these omit the " quotes.
now in your make table query in the criteria for the date
you would enter "Between forms.YourForm.Start and
forms.YourFom.End "
Again omit the " quotes.
You can now create a macro to run the make table query and
the crosstab query and than print the report, one after
the other. And on the form make one button to run this
macro.
All done.
Fons
-----Original Message-----
Bugger

Im well on the way to finishing this and would hate to even think about
starting again, will look into it though, cheers

:

If I am reading this correctly, you use a query with some
parameter(s) to create a table, from which you run a
crosstab query, which you use for a report, now you wish
the report to reflect the paramerters used in the make-
table query.
The best way to accomplish this would be to start with
creating a form with unbound textbox(es) where you would
enter your parameter(s), than while keeping this form
open, use these parameter(s) in your make-table query,and
run the crosstab query and ultimately the report.
Hope this helps.
Fons
-----Original Message-----
Im having trouble displaying the query data on my reports.
I have figured out how to display one set of the data,
that was 'site name',
however when trying to display the start/finish
Click to expand...
dates
of
the query I cant
find it the same way using the control source function.

I think the problem is that I have used a create table
query first then
completed a cross tab query to create the reports.
Changing the date formats
from 01-Nov-05 in the first query into either
Click to expand...
months
or
weeks depending on
the report.

Thanks for the help in advance
.


.
Click to expand...
Click to expand...
.
Click to expand...
 
Back
Top