Hi,

I am working in a sales database and need to compile an if statement with 2 arguments, I have the first part working:

=Count(IIf([Table1].[STATUS]=1,0))

This counts the records in a table that have status 1, but I also need to count those that have status 1 and the category field as 'Cold' (this is in the control source of a text box on a form).

This is my first time using this forum - so lets hope you can help me, I have been searching google and playing with this formula for 2 hours now, pleeeeeeease help!

Cheers,

Debbie