SQL On Form

[anon47]

I have the code be low that is giving me an error "The SELECT stament encludes a reserve word..." I am trying to get this code to pull a report on the employees and list them and there time to make it easy for accounting. HELP

SELECT DISTINCTROW Employees.SSN, Employees.Name AS Name Employees.PayRate AS PayRate Employees.TotalTime AS Time FROM Employees WHERE (((Employees.Inactive)=No) AND ((Employees.SSN) Is Not Null)) GROUP BY Employees.SSN;

 

[PHV]

What about this ?
SELECT DISTINCT SSN, [Name], PayRate, TotalTime AS [Time]
FROM Employees
WHERE Inactive = False AND SSN Is Not Null

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[anon47]

Perfect Many thanks

 

[TheAceMan1]

How are ya anon47 . . .

See the errors in red:

[blue]SELECT DISTINCTROW Employees.SSN,  Employees.Name AS Name[COLOR=white red],[/color] Employees.PayRate AS PayRate Employees.TotalTime AS [COLOR=white red]Time[/color] FROM Employees WHERE (((Employees.Inactive)=No) AND ((Employees.SSN) Is Not Null)) GROUP BY Employees.SSN;[/blue]

Not a good idea using reserved words as with [COLOR=white red]Time[/color].

See Ya! . . . . . .

Be sure to see FAQ219-2884:

 

[JoeAtWork]

This would be one of those times when the error message is actually telling you exactly what's wrong.

 

[TheAceMan1]

Howdy JoeAtWork . . .

True that! . . . and if your not an experienced VBA programmer . . . then what!? . . .

See Ya! . . . . . .

Be sure to see FAQ219-2884:

 

[TheAceMan1]

Howdy JoeAtWork . . .

True that! . . . [blue]and if your not an experienced VBA programmer[/blue] . . . [purple]then what!?[/purple] . . .

See Ya! . . . . . .

Be sure to see FAQ219-2884:

 

[JoeAtWork]

>> then what?
Perhaps look up "reserved words" in help?