Data in a Query not populating in Report

[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.

 

[Duane Hookom]

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]

 

[ACSOTECH]

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.

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

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.

 

[Duane Hookom]

I would try removing the text box and adding it back in. It may be invisible.
--
Duane Hookom
Microsoft Access MVP

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.

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

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.