My queries before a union have numbers formatted as currency. After the union query, I lose the currency format and numbers have a large number of decimal places. I've triedbut the results are text, not numbers. I've tried using the same format in both the union query itself and a subsequent query. I don't know what to try next
Format([$USUnit Price],0.00,2),