Invalid Arguement Error

[In need of assistance]

This feels like something simple that I just can put my finger on, hopefull
someone can help.

I'm trying to run a simple select query, and when I try to save the query,
I get the error "Invalid Arguement." I've included the error and the query
below.


The Query:
SELECT [2006 Voter File].ID, [2006 Voter File].CountyIDNumber, [2006 Voter
File].VoterNameLast, [2006 Voter File].VoterNameFirst, [2006 Voter
File].VoterNameMiddle, [2006 Voter File].VoterNameSuffix, [2006 Voter
File].ResidentAddress, [2006 Voter File].ResidentCity, [2006 Voter
File].ResidentZipCode, [2006 Voter File].TelephoneNumber, [2006 Voter
File].RegistrationDate, [2006 Voter File].StatusCode, [2006 Voter
File].BirthDate, [2006 Voter File].Sex, [2006 Voter File].PartyAffiliation,
[2006 Voter File].PartyAffiliationDate, [2006 Voter
File].CongressionalDistrict, [2006 Voter File].SenateDistrict, [2006 Voter
File].HouseDistrict, [2006 Voter File].PrecinctNumber
FROM [2006 Voter File]
WHERE ((Not ([2006 Voter File].SenateDistrict)=13) AND (([2006 Voter
File].HouseDistrict)=65));

The Error Help Message:
Invalid argument. (Error 3001)
You tried to perform an operation that involves a routine in a DLL, and one
of the arguments to the routine is invalid. Check your entry to make sure you
have specified the correct arguments, and then try the operation again.

This error also occurs when you attempt to use mutually exclusive constants
in an argument to a method, such as specifying both dbConsistent and
dbInconsistent in the options argument to the OpenRecordset method.

 

[arthurjr07]

have a look at this

http://www.granite.ab.ca/access/corruption/symptoms.htm

 

[Gary Walter]

This feels like something simple that I just can put my finger on,
hopefull
someone can help.

I'm trying to run a simple select query, and when I try to save the
query,
I get the error "Invalid Arguement." I've included the error and the
query
below.


The Query:
SELECT [2006 Voter File].ID, [2006 Voter File].CountyIDNumber, [2006 Voter
File].VoterNameLast, [2006 Voter File].VoterNameFirst, [2006 Voter
File].VoterNameMiddle, [2006 Voter File].VoterNameSuffix, [2006 Voter
File].ResidentAddress, [2006 Voter File].ResidentCity, [2006 Voter
File].ResidentZipCode, [2006 Voter File].TelephoneNumber, [2006 Voter
File].RegistrationDate, [2006 Voter File].StatusCode, [2006 Voter
File].BirthDate, [2006 Voter File].Sex, [2006 Voter
File].PartyAffiliation,
[2006 Voter File].PartyAffiliationDate, [2006 Voter
File].CongressionalDistrict, [2006 Voter File].SenateDistrict, [2006 Voter
File].HouseDistrict, [2006 Voter File].PrecinctNumber
FROM [2006 Voter File]
WHERE ((Not ([2006 Voter File].SenateDistrict)=13) AND (([2006 Voter
File].HouseDistrict)=65));

The Error Help Message:
Invalid argument. (Error 3001)
You tried to perform an operation that involves a routine in a DLL, and
one
of the arguments to the routine is invalid. Check your entry to make sure
you
have specified the correct arguments, and then try the operation again.

This error also occurs when you attempt to use mutually exclusive
constants
in an argument to a method, such as specifying both dbConsistent and
dbInconsistent in the options argument to the OpenRecordset method.

Arthur may be correct about corruption
I don't know...

but I might also look at your WHERE clause

what happens if you change to

WHERE
([2006 Voter File].SenateDistrict<>13)
AND
([2006 Voter File].HouseDistrict=65);

 

[Gary Walter]

This feels like something simple that I just can put my finger on,
hopefull
someone can help.

I'm trying to run a simple select query, and when I try to save the
query,
I get the error "Invalid Arguement." I've included the error and the
query
below.


The Query:
SELECT [2006 Voter File].ID, [2006 Voter File].CountyIDNumber, [2006
Voter
File].VoterNameLast, [2006 Voter File].VoterNameFirst, [2006 Voter
File].VoterNameMiddle, [2006 Voter File].VoterNameSuffix, [2006 Voter
File].ResidentAddress, [2006 Voter File].ResidentCity, [2006 Voter
File].ResidentZipCode, [2006 Voter File].TelephoneNumber, [2006 Voter
File].RegistrationDate, [2006 Voter File].StatusCode, [2006 Voter
File].BirthDate, [2006 Voter File].Sex, [2006 Voter
File].PartyAffiliation,
[2006 Voter File].PartyAffiliationDate, [2006 Voter
File].CongressionalDistrict, [2006 Voter File].SenateDistrict, [2006
Voter
File].HouseDistrict, [2006 Voter File].PrecinctNumber
FROM [2006 Voter File]
WHERE ((Not ([2006 Voter File].SenateDistrict)=13) AND (([2006 Voter
File].HouseDistrict)=65));

The Error Help Message:
Invalid argument. (Error 3001)
You tried to perform an operation that involves a routine in a DLL, and
one
of the arguments to the routine is invalid. Check your entry to make sure
you
have specified the correct arguments, and then try the operation again.

This error also occurs when you attempt to use mutually exclusive
constants
in an argument to a method, such as specifying both dbConsistent and
dbInconsistent in the options argument to the OpenRecordset method.

Arthur may be correct about corruption
I don't know...

but I might also look at your WHERE clause

what happens if you change to

WHERE
([2006 Voter File].SenateDistrict<>13)
AND
([2006 Voter File].HouseDistrict=65);

even better

WHERE
(Nz([2006 Voter File].SenateDistrict, 0) <> 13)
AND
([2006 Voter File].HouseDistrict=65);