Data in a Query not populating in Report

  • Thread starter Thread starter ACSOTECH
  • Start date Start date
A

ACSOTECH

I have a query that contains 3 calculated fields - SubTotal, Sales Tax &
DeptTotal. All calculated fields return correct values in the Query, but
when a run a report whether through a wizard or manually, the Sales Tax
Header shows but there is no data in the report. The query field is Sales
Tax: Format(([Unit Price]*[Units]*[Sales Tax Rate]),"Currency"). I think you
can see that it is a pretty simplistic report.
 
I'm not sure if this is your problem but there is generally no need to apply
a format in the report's record source. Set the format in the report control:
Sales Tax: [Unit Price]*[Units]*[Sales Tax Rate]
 
No! I don't believe this is the problem. Using the format option in
'properties' basically accomplishes the same result. I'm pretty sure it is
something to do with the formulas themselves. Am continuing to hammer on it.
Thanks for taking a shot at it.

Duane Hookom said:
I'm not sure if this is your problem but there is generally no need to apply
a format in the report's record source. Set the format in the report control:
Sales Tax: [Unit Price]*[Units]*[Sales Tax Rate]

--
Duane Hookom
Microsoft Access MVP


ACSOTECH said:
I have a query that contains 3 calculated fields - SubTotal, Sales Tax &
DeptTotal. All calculated fields return correct values in the Query, but
when a run a report whether through a wizard or manually, the Sales Tax
Header shows but there is no data in the report. The query field is Sales
Tax: Format(([Unit Price]*[Units]*[Sales Tax Rate]),"Currency"). I think you
can see that it is a pretty simplistic report.
Click to expand...
Click to expand...
 
I would try removing the text box and adding it back in. It may be invisible.
--
Duane Hookom
Microsoft Access MVP


ACSOTECH said:
No! I don't believe this is the problem. Using the format option in
'properties' basically accomplishes the same result. I'm pretty sure it is
something to do with the formulas themselves. Am continuing to hammer on it.
Thanks for taking a shot at it.

Duane Hookom said:
I'm not sure if this is your problem but there is generally no need to apply
a format in the report's record source. Set the format in the report control:
Sales Tax: [Unit Price]*[Units]*[Sales Tax Rate]

--
Duane Hookom
Microsoft Access MVP


ACSOTECH said:
I have a query that contains 3 calculated fields - SubTotal, Sales Tax &
DeptTotal. All calculated fields return correct values in the Query, but
when a run a report whether through a wizard or manually, the Sales Tax
Header shows but there is no data in the report. The query field is Sales
Tax: Format(([Unit Price]*[Units]*[Sales Tax Rate]),"Currency"). I think you
can see that it is a pretty simplistic report.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top