Bring selected information to report

[luizvin]

I'm having some problems with my report
and i will try to explain what is happening:

1. I have one table with information about student, including the column "STATUS" that is represented by the value list with the row source: "Current", "Applicant", "Graduated", and "Transferred";
2. I'm trying to bring to my report only the students that are "Current" and "Applicant", and I'm having some problems with that.

What i'm doing is the following:

1. I added a group with the following expression in my report:=IIf([STATUS]="Current","",IIf([STATUS]="Applicant",""IIf([STATUS]="Graduated","",IIf([STATUS]="Transferred","")));
2. Added also a text box with the data source STATUS.

But is not working

Please Help me !!

Thanks !!

 

[vbaInet]

Create a query based on your table and under the Status field put:

"Applicant" OR "Current"

In the Record Source property of your report, change it to this query you just created.

 

[CBrighton]

It sounds like your report is running directly on the table and you are trying to filter it via group headers?

Rather than running the report on the table, create a query which has

"Current" or "Applicant"

as the criteria in the STATUS field.

Then set the report control source to the query instead of the table.

:Edit:

What he said... takes me too long to post!

 

[vbaInet]

:Edit:

What he said... takes me too long to post!

Keep up C

 

[luizvin]

Create a query based on your table and under the Status field put:

"Applicant" OR "Current"

In the Record Source property of your report, change it to this query you just created.

Ok Thank you for reply
But I'm still having some problems
when i change the data source to the Query i already create a window appears telling "Enter Parameter Value" then Query 1 (the query I created)

 

[CBrighton]

Can you copy the SQL of your query and paste it here please?

 

[luizvin]

Ok now i got it,
Thank you so much
I was breaking my head trying to solve this problem
you were very helpful

 

[vbaInet]

CBrighton was much faster

Glad to hear you have it working now luizvin.

 

[CBrighton]

Keep up V

 

[vbaInet]

Keep up V

I'll try