-
If statements
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
-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules