Unanswered: Access 2003 - Data Mismatch error in query
· I have an Access 2003 query that pulls about 20 fields from several ODBC data sources, one of which is dbo_OptimizeIt_ExcessUsages. · I use Group By to group the fields and for the field “Quantity” I use SUM. · I also need to select only those records where the summed quantity is greater than or equal to 7,000. · The quantity sums fine but when I try to enter the criteria to select only those records where the summed quantity is greater than or equal to 7,000 (>=7000) I get a “Data Mismatch” error. · In addition to using >=7000 I also tried using CSng((Sum([dbo_OptimizeIt_ExcessUsages].[Quantity]))>=7600) but that gives me no data and I know data is there.