access11899
New member
- Local time
- Today, 14:58
- Joined
- Oct 19, 2011
- Messages
- 6
Hi I'm a beginner
I have a problem in displaying two parameters in a report
The report is based on the following query:
SELECT summaryTable.ACCOUNT, Round((Sum(SummaryTable.Time)*24*60)/60)+((Sum(SummaryTable.Time)*24*60) Mod 60)/100 AS WORKED_HOUR
FROM summaryTable
WHERE summaryTable.date Between [from] And [TO]
GROUP BY summaryTable.ACCOUNT
ORDER BY Round((Sum(SummaryTable.Time)*24*60)/60)+((Sum(SummaryTable.Time)*24*60) Mod 60)/100 DESC;
The parameters I want to display are [from] And [TO].
I have already tried to create
1)text box in the report
2)and typed in =[from] for text box 1 and =[TO] for text box 2.
The reports works and displays a table graph but instead of displaying the two parameters all I get is #Name?
I have made sure that the text in the text boxes is exactly the same as the sql query [from] and [TO].
Many thanks for your help
I have a problem in displaying two parameters in a report
The report is based on the following query:
SELECT summaryTable.ACCOUNT, Round((Sum(SummaryTable.Time)*24*60)/60)+((Sum(SummaryTable.Time)*24*60) Mod 60)/100 AS WORKED_HOUR
FROM summaryTable
WHERE summaryTable.date Between [from] And [TO]
GROUP BY summaryTable.ACCOUNT
ORDER BY Round((Sum(SummaryTable.Time)*24*60)/60)+((Sum(SummaryTable.Time)*24*60) Mod 60)/100 DESC;
The parameters I want to display are [from] And [TO].
I have already tried to create
1)text box in the report
2)and typed in =[from] for text box 1 and =[TO] for text box 2.
The reports works and displays a table graph but instead of displaying the two parameters all I get is #Name?
I have made sure that the text in the text boxes is exactly the same as the sql query [from] and [TO].
Many thanks for your help