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...
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...