Different results when using views and tables

Hello,

I'm a simple group by query against a view to get subtotals but I'm getting some odd results.

When I run the query directly against the view, the subtotals add up to 205 records even though the view returns 207 records. When I put the view's results into a table using SELECT * INTO and then rerun the query. the subtotals add up to 207 as expected. Does anyone know why I'm getting different results?

Regards

Paulie

In my experience something like this is either some sort of bad data or some sort of corruption.

Things you can try to solve the mystery:

1. Copy the SQL to a new query using the same view and see if you get the correct totals.
2. Change the field you are using for the count. This may not be possible if you only have one field that consistently has data.
3. Investigate the original data by tracking down which subtotals are different. There may be some sort wierd corruption in the orignal data that gets cleaned in the Select * into.
4. Create a new Database file and import everything from the old file into it.