I have created a report in an adp based on a query of a settlements table i have in my database. The field i am having trouble with is a calculated fields sum dropping cents. The field is ...

That way when you run either they return the same fields.<BR>Once the queries look the same, make a third query that UNIONS the 2 together. That will combine the results from both queries.