Access 2000 Report Question

Hello, I have a report in access that gets ORDERID, PROID, and ORDERS from a table. It's details part of the report gets all the total orders, and lists them by ORDER ID. We have a wildcard though, an ORDERID of "TYC" contains orders that should go into "ABC" and "YYZ". If the first leter of the PROID is an "A", the orders go in the ABC....else it goes in YYZ...how can hae my report do this if/then, and then add it to the results?

You could use 2 formulas. One called ABC and the other called YYZ. You can code an if then else statement that will separate the orderid and proid.