Show all Records

[Guest]

I have a form where of a option group I select one option and that opens a
combobox from where I can select the required name for which I need a report
and when I run report it will show me the report of the activity of that
individual.
But what I want to do is if I do not select any name then the report must
show me all the records of all the people in the database.
I am running a macro to filter record which is like this
[Name]=[Forms]![Report Form]![NameCombo]
Any suggestion on what I cna change to show all records if nothing is
selected in the namecombombo box.
Thanks

 

[Larry Daugherty]

Maybe this would work for you:

"*" & [Name]=[Forms]![Report Form]![NameCombo] & "*"

HTH

 

[Guest]

Hi Larry
It works in a funny way. As It doesnot give the value in group by area.
and also When I select a perticular name it showes no record.

Maybe this would work for you:

"*" & [Name]=[Forms]![Report Form]![NameCombo] & "*"

HTH
--
-Larry-
--

I have a form where of a option group I select one option and that opens a
combobox from where I can select the required name for which I need a report
and when I run report it will show me the report of the activity of that
individual.
But what I want to do is if I do not select any name then the report must
show me all the records of all the people in the database.
I am running a macro to filter record which is like this
[Name]=[Forms]![Report Form]![NameCombo]
Any suggestion on what I cna change to show all records if nothing is
selected in the namecombombo box.
Thanks

 

[John Vinson]

Any suggestion on what I cna change to show all records if nothing is
selected in the namecombombo box.

[Name]=[Forms]![Report Form]![NameCombo]
OR [Forms]![Report Form]![NameCombo] IS NULL


John W. Vinson[MVP]

 

[Larry Daugherty]

My first response to you was based on a wild guess that you were
looking for something for the criteria line in the QBE grid or its
equivalent.

You have given us no information that gives us clues as to what you
are doing and where.

If you'll post back with a detailed description of what you're doing
and what you've tried so far then someone will probably pick up this
thread and help you.

HTH
--
-Larry-
--

Hi Larry
It works in a funny way. As It doesnot give the value in group by area.
and also When I select a perticular name it showes no record.

Maybe this would work for you:

"*" & [Name]=[Forms]![Report Form]![NameCombo] & "*"

HTH
--
-Larry-
--

I have a form where of a option group I select one option and

that
opens a

combobox from where I can select the required name for which I

need
a report

and when I run report it will show me the report of the activity

of
that

individual.
But what I want to do is if I do not select any name then the

report
must

show me all the records of all the people in the database.
I am running a macro to filter record which is like this
[Name]=[Forms]![Report Form]![NameCombo]
Any suggestion on what I cna change to show all records if

nothing
is

selected in the namecombombo box.
Thanks