Recent content by Fairman

Thanks jzwp22 for getting me back on track. I was able to fashion another query that used subtraction on the codes. The application is used for billing services and so I was able to fix this subtraction of related items. I ended up with three queries all brought together in a union Query. Thank...

Please help me if you can. I have two separate queries that give the following results. QueryOne EventCode, EventWkCode, SumOfwkHours 23062, PP, 89.5 23062, B, 141 23062, F, 47.5 QueryTwo EventCode, EventWkCode, SumOfwkHours 23062, F_UST, 5 I need to subtract QueryTwo from from...