User data entered to be displayed after entering in a report via query? 1

[aph]

Hi all I have a report that has a graph in it from a query the data from the query is generated via a user input of the user entering two dates. Is there any way of not only displying the graph which is working correctly but also to dates entered from the user in the report?

Kind regards
Andy

 

[PHV]

How is the user entering two dates ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[aph]

Hi PHV,
Via Text box that appears when Query is run
E.G Please enter start date "user enters date"
Please enter end date "user enters date"

Done via Criteria in the query

 

[PHV]

What is the SQL code of your query ?


Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[aph]

err don't know how do i see the code?

 

[PHV]

SQL View pane

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[aph]

here it is

SELECT error_log_table.ppl_date_el, error_log_table.unit_el, error_log_table.d_number_el, error_log_table.customer_el, error_log_table.bag_reference_el, error_log_table.error_type_el, error_log_table.quantity_el, error_log_table.disposition_el, error_log_table.notes_el, error_log_table.ppl_name_el, error_log_table.[ppl_position-el]
FROM error_log_table
WHERE (((error_log_table.ppl_date_el) Between [Enter start date] And [Enter ending date]));

 

[PHV]

Use the following SQL code and then you may bind textboxes in your report to StartDate and EndDate:
SELECT ppl_date_el, unit_el, d_number_el, customer_el, bag_reference_el, error_type_el, quantity_el, disposition_el, notes_el, ppl_name_el, [ppl_position-el][!], [Enter start date] AS StartDate, [Enter ending date] AS EndDate[/!]
FROM error_log_table
WHERE ppl_date_el Between [Enter start date] And [Enter ending date]

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[aph]

Cheers I'll give it ago tomorrow at work

 

[aph]

Hi finally got to try it and I'm getting this appearing in the text boxes #Name?

 

[dhookom]

Please provide your SQL, the control name, and the control source.

Duane
Hook'D on Access
MS Access MVP

 

[aph]

the sql is listed above

control name, and the control source

don't know what you mean?

 

[dhookom]

Your "text boxes #Name?" have control name and control source properties.

Did you copy and use PHV's SQL exactly as suggested?

Duane
Hook'D on Access
MS Access MVP

 

[aph]

yup used the code i'll re do it tomorrow and post back

 

[dhookom]

IMO faq701-6763

Duane
Hook'D on Access
MS Access MVP

 

[aph]

Ok had another go with the same code with same result control name control sourse are as follows

Start date is
Control name Text7
Control source =[Errors Via Type 2]![StartDate]

Finish date
Control Name Text9
Control Source =[Errors Via Type 2]![EndDate]

 

[dhookom]

I'm not sure why you are using "=[Errors Via Type 2]!". You should be able to select the field/column name in the control source.

[StartDate]

Duane
Hook'D on Access
MS Access MVP