Good evening,
I need some help with a query which has been working for years, and just now is giving me a error.
The query calculates income tax - Taxes: (SELECT T.[TaxAmount] FROM IncomeTax AS T WHERE [PayRoll Table].GROSS Between T.PayRangeLow And T.PayRangeHigh)
It is an append query and does not append the data. The error is "AT most one record can be returned by this subquery.
I switched to a select query. The query actually runs and shows the data but when you try to select the date to copy it give the same error.
Nothing was changed in the Database. The Income Tax table remained the same.
Any ideas why that would happen?
Thanks
Cristina
I need some help with a query which has been working for years, and just now is giving me a error.
The query calculates income tax - Taxes: (SELECT T.[TaxAmount] FROM IncomeTax AS T WHERE [PayRoll Table].GROSS Between T.PayRangeLow And T.PayRangeHigh)
It is an append query and does not append the data. The error is "AT most one record can be returned by this subquery.
I switched to a select query. The query actually runs and shows the data but when you try to select the date to copy it give the same error.
Nothing was changed in the Database. The Income Tax table remained the same.
Any ideas why that would happen?
Thanks
Cristina