The schema returned by the new query differs from the base query

  • Thread starter Thread starter Ravi Kumar12233
  • Start date Start date
R

Ravi Kumar12233

Guest
hello all ,

I have created a data-grid box from access table containing columns as below :

SELECT ID, [Size in mg], [Die head number], [Inspection Date], [Next Calibration Date], [Die size in microns], [Condition of DIE-1], [Condition of DIE-2], [Condition of DIE-3], [Condition of DIE-4], [Condition of DIE-5], [Condition of DIE-6], [Condition of DIE-7], Observations, Inspector FROM MSdies


But when i tried to create a query as below the error message is coming saying:

The schema returned by the new query differs from the base query

SELECT ID, [Size in mg], [Die head number], [Inspection Date], [Next Calibration Date], [Die size in microns]
FROM MSdies
WHERE ([Die head number] < NOW())
Please guide me how to solve this

Continue reading...
 
Back
Top