Originally Posted by
FranCorona
Here is the SQL statement that works but brings up the parameter box: (I had to put in the [] on all of the fields because it said it could not find them)SELECT [BCT Unit], [Grid Model], [Admin], [FMC Cost Out], "FMC Cost Out" AS Source From [Rotational Grid] Where Not [FMC Cost Out] Is Null
UNION SELECT [BCT Unit], [Grid Model], [Admin], [NMC Cost Out], “NMC Cost Out" FROM [Rotational Grid] Where Not [NMC Cost Out] Is Null
UNION SELECT [BCT Unit], [Grid Model], [Admin], [Warranty], "Warranty" FROM [Rotational Grid] Where Not [Warranty] Is Null;
When I try to put in the AS Costs into the SQL statement it comes up with this message when I try to run it:
The SELECT statement includes a reserved word or an argument name that is misspelled or missing, or the punctuation is incorrect.