Data Range

[YukiLeong]

I have a small problem. I have a report based on a query which requires the user
to input the date range. I would like this date range to be a label in the
report.

i already keying tha formula fo the data range.. Audit Fees
Report is my form

Between [Forms]![Purchase Report]![From] And [Forms]![Purchase Report]![To]

I am trying to run a report for the period
"December 1 2010 to March 31 2011" However, it came out a warning message
box.

" the expression is typed incorrectly or it is too complex....bla
..ba....try simplifying the expression by assigning parts pf the expression to
variables"

anything wrong for my formula?

 

[ranman256]

I found that a problem too...( Hey Access, its not really complex)
BUT what I did is:
create a text box (mine is invisible to user) called txtRng. When the user clicks the open report button, a small code writes the 'text' version of the date range ....
txtRng = "From " & [Forms]![Purchase Report]![From] & " to " & [Forms]![Purchase Report]![To]
then opens the report, and the query has a virtual field : [Forms]![Purchase Report]![txtRng]

Access cant calculate that formula but it CAN just display the text box value.

 

[YukiLeong]

I found that a problem too...( Hey Access, its not really complex)
BUT what I did is:
create a text box (mine is invisible to user) called txtRng. When the user clicks the open report button, a small code writes the 'text' version of the date range ....
txtRng = "From " & [Forms]![Purchase Report]![From] & " to " & [Forms]![Purchase Report]![To]
then opens the report, and the query has a virtual field : [Forms]![Purchase Report]![txtRng]

Access cant calculate that formula but it CAN just display the text box value.

Hi..
I change the criteria ard, although the warning message will not pop up again...However, after i key the date range, my report dose not show any information, all report is blank..anything i doing wrong? below is my SQL view...

SELECT tblAuditFees.InvoiceID AS tblAuditFees_InvoiceID, tblAuditFees.InvoiceDate, tblAuditFees.CustomerID, tblCustomer.CustomerName, tblAuditFees.EmployeeID, tblEmployee.EmployeeName, tblAuditFees.BasicAuditFees, tblAuditFees.VolumeOfTrasaction, tblAuditFees.ControlRisk, tblAuditFees.InherentRisk, tblAuditFees.ProfitOfCompany, tblAuditFees.Workload, tblAuditFees.AdditionCharge, tblAuditFees.TotalAuditFees
FROM tblCustomer INNER JOIN (tblEmployee INNER JOIN tblAuditFees ON tblEmployee.EmployeeID = tblAuditFees.EmployeeID) ON tblCustomer.CustomerID = tblAuditFees.CustomerID
WHERE ((("txtDate")="From" & [Forms]![AuditFeesReport]![From] & "to" & [Forms]![AuditFeesReport]![To]));


Thanks...

 

[YukiLeong]

Hi..
I change the criteria ard, although the warning message will not pop up again...However, after i key the date range, my report dose not show any information, all report is blank..anything i doing wrong? below is my SQL view...

SELECT tblAuditFees.InvoiceID AS tblAuditFees_InvoiceID, tblAuditFees.InvoiceDate, tblAuditFees.CustomerID, tblCustomer.CustomerName, tblAuditFees.EmployeeID, tblEmployee.EmployeeName, tblAuditFees.BasicAuditFees, tblAuditFees.VolumeOfTrasaction, tblAuditFees.ControlRisk, tblAuditFees.InherentRisk, tblAuditFees.ProfitOfCompany, tblAuditFees.Workload, tblAuditFees.AdditionCharge, tblAuditFees.TotalAuditFees
FROM tblCustomer INNER JOIN (tblEmployee INNER JOIN tblAuditFees ON tblEmployee.EmployeeID = tblAuditFees.EmployeeID) ON tblCustomer.CustomerID = tblAuditFees.CustomerID
WHERE ((("txtDate")="From" & [Forms]![AuditFeesReport]![From] & "to" & [Forms]![AuditFeesReport]![To]));


Thanks...

hihi...i ard find the solution to solve it.. it use >
=[Forms]![AuditFeesReport]![From] And <=[Forms]![AuditFeesReport]![To] ...thanks...