Filter

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

J - 09 Jan 2006 13:25 GMT

I have a report that I want to filter out certain records when the user
enters a specific number of a field in a table. So far I'm at the
point where I can enter in which value that I would like to filter when
I open the report. The big problem at the moment is that no matter
which number that I enter, the report brings back all records within
the table even if the records don't have any values entered in. Any
help with my filtering problem would be greatly appreciated.

Reply to this Message

Douglas J Steele - 09 Jan 2006 13:31 GMT

How are you attempting to use the value that you've entered?

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

> I have a report that I want to filter out certain records when the user
> enters a specific number of a field in a table. So far I'm at the
[quoted text clipped - 3 lines]
> the table even if the records don't have any values entered in. Any
> help with my filtering problem would be greatly appreciated.

Reply to this Message

J - 09 Jan 2006 13:35 GMT

I just want to use the value that I enter to search through the table
and create a report based on all fields that have that particular
number under the field name.

Reply to this Message

Douglas J Steele - 09 Jan 2006 16:04 GMT

I understand that. However, you said "So far I'm at the point where I can
enter in which value that I would like to filter when
I open the report. The big problem at the moment is that no matter which
number that I enter, the report brings back all records within the table
even if the records don't have any values entered in."

How are you determining what number to use, and how are you trying to open
the report? In other words, show us the code you're using.

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

> I just want to use the value that I enter to search through the table
> and create a report based on all fields that have that particular
> number under the field name.

Reply to this Message

J - 09 Jan 2006 16:30 GMT

I have it figured out now

Reply to this Message