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?