Omitting ($0) records and eliminating the space

[Guest]

Please help. I've been tasked w/the assignment of creating an access
database. My knowledge is very limited. However, I've managed to create
tables (from Excel info), a query, and a report. There are over 20 fields
containing dollar amounts listed on the report. Many of the records are $0.
I would like to eliminate those records from appearing and only generate the
ones that have >$0 on the report. I think I'll need to use the following
type of command IIF(isnull(report!Reportname.Field),[Field1],[Field2], but I
don't know where to put it.

SOS....enjay

 

[Al Campagna]

enjay,
You should do that in the query behind the report. Create a query where those money
fields have a criteria of

0

--
hth
Al Campagna
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

Please help. I've been tasked w/the assignment of creating an access
database. My knowledge is very limited. However, I've managed to create
tables (from Excel info), a query, and a report. There are over 20 fields
containing dollar amounts listed on the report. Many of the records are $0.
I would like to eliminate those records from appearing and only generate the
ones that have >$0 on the report. I think I'll need to use the following
type of command IIF(isnull(report!Reportname.Field),[Field1],[Field2], but I
don't know where to put it.

SOS....enjay

 

[Guest]

Thanks for responding, however the entire table disappeared when I made >0 a
criteria for only one of the fields. The amounts in each record change
monthly. One month there are no charges for a certain service, but the next
month two or three individuals may have charges for that service. What am I
to do?

enjay,
You should do that in the query behind the report. Create a query where those money
fields have a criteria of

0

--
hth
Al Campagna
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

Please help. I've been tasked w/the assignment of creating an access
database. My knowledge is very limited. However, I've managed to create
tables (from Excel info), a query, and a report. There are over 20 fields
containing dollar amounts listed on the report. Many of the records are $0.
I would like to eliminate those records from appearing and only generate the
ones that have >$0 on the report. I think I'll need to use the following
type of command IIF(isnull(report!Reportname.Field),[Field1],[Field2], but I
don't know where to put it.

SOS....enjay

 

[Al Campagna]

enjay,
That shouldn't happen, so there's something amiss, or were missing some information
about your setup.
If you have several individual fields with money amounts in each record, >0 in only 1
field should not cause all your other fields to not display.

Can you show me some sample data (3 or 4 example Records... you don'y have to show All
fields, just enough to get a representative look at the table design and some of your
data)... including field names.
What you have for data vs. what you'd like to see on the report...

--
hth
Al Campagna
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

Thanks for responding, however the entire table disappeared when I made >0 a
criteria for only one of the fields. The amounts in each record change
monthly. One month there are no charges for a certain service, but the next
month two or three individuals may have charges for that service. What am I
to do?

enjay,
You should do that in the query behind the report. Create a query where those money
fields have a criteria of

0

--
hth
Al Campagna
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

Please help. I've been tasked w/the assignment of creating an access
database. My knowledge is very limited. However, I've managed to create
tables (from Excel info), a query, and a report. There are over 20 fields
containing dollar amounts listed on the report. Many of the records are $0.
I would like to eliminate those records from appearing and only generate the
ones that have >$0 on the report. I think I'll need to use the following
type of command IIF(isnull(report!Reportname.Field),[Field1],[Field2], but I
don't know where to put it.

SOS....enjay