Combo Box In Report

[baum12]

I have a combo box with 3 things in it from the form.
Funded
Completed
Pending

I want to run the report so that it combines Funded and Completed entries.

As it is now, it groups by each category. What kind of statement needs to go in the query builder so that I can combine the Funded and Completed to print altogether?

Thank you for any help! I appreciate it!

 

[DCrake]

Create an extra column in your query

GrpBy:IIF([FieldName]='Pending',1,0)

Then use the column GrpBy as your grouping fild in your report.

 

[baum12]

Can you take a look and tell me where that goes exactly? What I have done does not work. Thank you so much for responding!

 

[boblarson]

You don't display a combo box on the report. You should have status as a field in your report's record source and then you just bind that text box to that field. I am guessing that you have defined lookups at table level and this is why that is a bad idea:
http://www.mvps.org/access/lookupfields.htm

 

[baum12]

Hi,

Yes, you guessed it, I had a table with a lookup table. Ok, so I changed that and just made it a field in the table where you will type either
Funded
Completed
Pending

I have attached another screenshot if you don't mind taking a look with some more explanation of what I need. Thanks for responding so quickly!