Enter Parameter Value

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am new to Access so this may be a basic question: I have revised fields in my table to display "Unknown" and now am trying to create Queries that inlcude the unknown fields and one that excludes all unknown fields. I have been able to create the first one, though an Enter Parameter Value box appears with the word Unknown. The query that I am trying to exclude all unknown fields as been less successful. Can somebody take a look at the SQL and tell me what I'm doing wrong?
SELECT [Type of Service], [Basis of Fee], [Date], [Name], [Employee Number], [Hours], [Task/Phase], [Phase Number]
FROM [General Payroll]
WHERE [Type of Service]<>Unknown And [Basis of Fee]<>Unknown;

Thank you in advance!
 
In your WHERE clause, the word Unknown should be enclosed
in quotes:
WHERE [Type of Service]<> "Unknown" And [Basis of Fee]
<> "Unknown";
so Access understands it is a text string. As it is,
Access takes it for a variable, thus the parameter input
text box.

Nikos
-----Original Message-----
I am new to Access so this may be a basic question: I
Click to expand...
have revised fields in my table to display "Unknown" and
now am trying to create Queries that inlcude the unknown
fields and one that excludes all unknown fields. I have
been able to create the first one, though an Enter
Parameter Value box appears with the word Unknown. The
query that I am trying to exclude all unknown fields as
been less successful. Can somebody take a look at the SQL
and tell me what I'm doing wrong?
SELECT [Type of Service], [Basis of Fee], [Date], [Name],
Click to expand...
[Employee Number], [Hours], [Task/Phase], [Phase Number]
FROM [General Payroll]
WHERE [Type of Service]<>Unknown And [Basis of Fee]
Click to expand...
 
Back
Top