not getting return expected

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a database that has figures in the field, one field is a long integer,
the other is currency. I have queried them and get the expected return.
When I try to do a report on the query. The long integer will not show on my
report. If I tell it to sum([field]) then my curreny will not show either.
What can I be doing wrong. Thanks
 
Do you see any numbers displaying on your report? Do you see the field and
values when viewing the report's record source in datasheet view?
 
I actually have a 0 showing where I expect a standard number, where the
currency is is fine. All the information shows just fine in the data sheet
veiw of my query, it just won't show on my report, other than the currency
figure.

Duane Hookom said:
Do you see any numbers displaying on your report? Do you see the field and
values when viewing the report's record source in datasheet view?

--
Duane Hookom
MS Access MVP
--

Akrt48 said:
I have a database that has figures in the field, one field is a long
integer,
the other is currency. I have queried them and get the expected return.
When I try to do a report on the query. The long integer will not show on
my
report. If I tell it to sum([field]) then my curreny will not show
either.
What can I be doing wrong. Thanks
Click to expand...
Click to expand...
 
We can't see the properties of the text boxes that are not working. Could
you provide these to us?

--
Duane Hookom
MS Access MVP
--

Akrt48 said:
I actually have a 0 showing where I expect a standard number, where the
currency is is fine. All the information shows just fine in the data
sheet
veiw of my query, it just won't show on my report, other than the currency
figure.

Duane Hookom said:
Do you see any numbers displaying on your report? Do you see the field
and
values when viewing the report's record source in datasheet view?

--
Duane Hookom
MS Access MVP
--

Akrt48 said:
I have a database that has figures in the field, one field is a long
integer,
the other is currency. I have queried them and get the expected
return.
When I try to do a report on the query. The long integer will not show
on
my
report. If I tell it to sum([field]) then my curreny will not show
either.
What can I be doing wrong. Thanks
Click to expand...
Click to expand...
Click to expand...
 
Just Standard and 0 decimal places, the other is currency and 0 decimal
places it must have something to do with order because I just added another
field to my table and query and now I can't see any of them on my report. If
I take away the new one, then my currency comes back. My frustration is
growing because I am sure you will tell me something simple.

Duane Hookom said:
We can't see the properties of the text boxes that are not working. Could
you provide these to us?

--
Duane Hookom
MS Access MVP
--

Akrt48 said:
I actually have a 0 showing where I expect a standard number, where the
currency is is fine. All the information shows just fine in the data
sheet
veiw of my query, it just won't show on my report, other than the currency
figure.

Duane Hookom said:
Do you see any numbers displaying on your report? Do you see the field
and
values when viewing the report's record source in datasheet view?

--
Duane Hookom
MS Access MVP
--

I have a database that has figures in the field, one field is a long
integer,
the other is currency. I have queried them and get the expected
return.
When I try to do a report on the query. The long integer will not show
on
my
report. If I tell it to sum([field]) then my curreny will not show
either.
What can I be doing wrong. Thanks
Click to expand...
Click to expand...
Click to expand...
 
I can't imagine any cause of this. Consider recreating your report.

--
Duane Hookom
MS Access MVP
--

Akrt48 said:
Just Standard and 0 decimal places, the other is currency and 0 decimal
places it must have something to do with order because I just added
another
field to my table and query and now I can't see any of them on my report.
If
I take away the new one, then my currency comes back. My frustration is
growing because I am sure you will tell me something simple.

Duane Hookom said:
We can't see the properties of the text boxes that are not working. Could
you provide these to us?

--
Duane Hookom
MS Access MVP
--

Akrt48 said:
I actually have a 0 showing where I expect a standard number, where the
currency is is fine. All the information shows just fine in the data
sheet
veiw of my query, it just won't show on my report, other than the
currency
figure.

:

Do you see any numbers displaying on your report? Do you see the field
and
values when viewing the report's record source in datasheet view?

--
Duane Hookom
MS Access MVP
--

I have a database that has figures in the field, one field is a long
integer,
the other is currency. I have queried them and get the expected
return.
When I try to do a report on the query. The long integer will not
show
on
my
report. If I tell it to sum([field]) then my curreny will not show
either.
What can I be doing wrong. Thanks
Click to expand...
Click to expand...
Click to expand...
 
I have solved it but no idea why, I had to make it into a sum query, then it
put the data in one line and will show it on the report. I tried to do a sum
field in the report, but that would not work. Very confusing, thanks for
taking the time.

Duane Hookom said:
I can't imagine any cause of this. Consider recreating your report.

--
Duane Hookom
MS Access MVP
--

Akrt48 said:
Just Standard and 0 decimal places, the other is currency and 0 decimal
places it must have something to do with order because I just added
another
field to my table and query and now I can't see any of them on my report.
If
I take away the new one, then my currency comes back. My frustration is
growing because I am sure you will tell me something simple.

Duane Hookom said:
We can't see the properties of the text boxes that are not working. Could
you provide these to us?

--
Duane Hookom
MS Access MVP
--

I actually have a 0 showing where I expect a standard number, where the
currency is is fine. All the information shows just fine in the data
sheet
veiw of my query, it just won't show on my report, other than the
currency
figure.

:

Do you see any numbers displaying on your report? Do you see the field
and
values when viewing the report's record source in datasheet view?

--
Duane Hookom
MS Access MVP
--

I have a database that has figures in the field, one field is a long
integer,
the other is currency. I have queried them and get the expected
return.
When I try to do a report on the query. The long integer will not
show
on
my
report. If I tell it to sum([field]) then my curreny will not show
either.
What can I be doing wrong. Thanks
Click to expand...
Click to expand...
Click to expand...
 
Back
Top