$0.00 in calculated field in report

[Marilyn K]

I am a very novice 2000 Acess user. Please Help!. I have an invoice with
many calculated fields. Everything works great when I work in a table of
form view. I am have trouble doing a report. I am only bring over 2
calculated field to my report (sub total and amoun due) and both fields show
$0.00 instead of the calculated amounts. What have I done wrong?

 

[Carl Rapson]

I am a very novice 2000 Acess user. Please Help!. I have an invoice with
many calculated fields. Everything works great when I work in a table of
form view. I am have trouble doing a report. I am only bring over 2
calculated field to my report (sub total and amoun due) and both fields
show
$0.00 instead of the calculated amounts. What have I done wrong?

It's hard to say. Are you using a query to create your calculated fields? If
so, you can use the same query as the source for the report, and you should
see all the same fields, including the calculated ones. If you're not using
a query, then how are you doing the calculations?

Carl Rapson

 

[Marilyn K]

Carl
Thanks for your response. Yes I am using a query to creat my report. But
as I stated, my calcualted fields are coming up with $0.00. I was using a
filter to only show between certain dates (example -
#1/1/2007#and#3/31/2007#) and ten running this filter. It returned all my
data between these dates but with the $0.00 calculated fields. I tried
removing the filter and came up with the same thing.
Marilyn

 

[Carl Rapson]

Can you post the query here? It's difficult to diagnose a query problem
without seeing the actual SQL code.

Carl Rapson

 

[Marilyn K]

Carl
Has I first stated I am a novice user. If you can guide me threw posting
the query I would be more than happy to. Your help is most appreciated.
Marilyn

 

[Carl Rapson]

Open your query in Design view and then use the View button on the menu bar
to switch to SQL View. Copy the code in that window and paste it in a
message here.

Carl Rapson

 

[Marilyn K]

Carl
I believe this is what you asked for. I will tell you that I manual went in
and extented the numbers. I changed no formulas or anything else. I hope
that you can figure this out. Thanks again.
Marilyn

SELECT [2007 Invoice Table].[Invoice #], [2007 Invoice Table].[Date], [2007
Invoice Table].[Name], [2007 Invoice Table].[Contact], [2007 Invoice
Table].[Quantity #1], [2007 Invoice Table].[Unit Price #1], [2007 Invoice
Table].[Amount #1], [2007 Invoice Table].[Quantity #2], [2007 Invoice
Table].[Unit Price #2], [2007 Invoice Table].[Amount #2], [2007 Invoice
Table].[Quantity #3], [2007 Invoice Table].[Unit Price #3], [2007 Invoice
Table].[Amount #3], [2007 Invoice Table].[Quantity #4], [2007 Invoice
Table].[Unit Price #4], [2007 Invoice Table].[Amount #4], [2007 Invoice
Table].[Sub Total], [2007 Invoice Table].[Tax], [2007 Invoice Table].[Amount
Due], [2007 Invoice Table].[Check #], [2007 Invoice Table].[Amount], [2007
Invoice Table].[Date Paid]
FROM [2007 Invoice Table]
WHERE ((([2007 Invoice Table].[Date Paid]) Between #3/1/2007# And
#3/31/2007#));

 

[Carl Rapson]

What do you mean, "extended the numbers"? I don't see any calculated fields
in your query. What are the calculations you are doing that result in the
zero values? If you run this query as it is, are all of the returned values
correct?

Carl Rapson

Carl
I believe this is what you asked for. I will tell you that I manual went
in
and extented the numbers. I changed no formulas or anything else. I hope
that you can figure this out. Thanks again.
Marilyn

SELECT [2007 Invoice Table].[Invoice #], [2007 Invoice Table].[Date],
[2007
Invoice Table].[Name], [2007 Invoice Table].[Contact], [2007 Invoice
Table].[Quantity #1], [2007 Invoice Table].[Unit Price #1], [2007 Invoice
Table].[Amount #1], [2007 Invoice Table].[Quantity #2], [2007 Invoice
Table].[Unit Price #2], [2007 Invoice Table].[Amount #2], [2007 Invoice
Table].[Quantity #3], [2007 Invoice Table].[Unit Price #3], [2007 Invoice
Table].[Amount #3], [2007 Invoice Table].[Quantity #4], [2007 Invoice
Table].[Unit Price #4], [2007 Invoice Table].[Amount #4], [2007 Invoice
Table].[Sub Total], [2007 Invoice Table].[Tax], [2007 Invoice
Table].[Amount
Due], [2007 Invoice Table].[Check #], [2007 Invoice Table].[Amount], [2007
Invoice Table].[Date Paid]
FROM [2007 Invoice Table]
WHERE ((([2007 Invoice Table].[Date Paid]) Between #3/1/2007# And
#3/31/2007#));

Open your query in Design view and then use the View button on the menu
bar
to switch to SQL View. Copy the code in that window and paste it in a
message here.

Carl Rapson