Re: Invalid Arguement Error


"Gary Walter" wrote:>
"In need of assistance" wrote:
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);


.

Relevant Pages

  • Re: Invalid Arguement Error
    ... I'm trying to run a simple select query, and when I try to save the ... I get the error "Invalid Arguement." ... [2006 Voter File].PartyAffiliationDate, [2006 Voter ... dbInconsistent in the options argument to the OpenRecordset method. ...
    (microsoft.public.access.queries)
  • Invalid Argument Error
    ... I'm not sure that I'm in the correct group. ... This morning I tried to execute my query. ... I modified my query and I when I went to save it, I got the "Invalid Argument" ... When I tried to compact and repair my db, I got the "Invalid Argument" error. ...
    (microsoft.public.access.setupconfig)
  • Re: A little help on a proc
    ... Do you care if the loginname is invalid? ... > So the best process is to rerun the query? ... >> create proc foo as ...
    (microsoft.public.sqlserver.programming)
  • Re: How do I temporarily limit values in a query field
    ... I am getting an error message: "The expression you entered has a invalid ..or! ... This is the last few lines of the 'old' sql with an attempt to limit the records to values of <500: ... works fine until I try to put limits on it value in the qryClaimDetails query. ...
    (microsoft.public.access.queries)
  • Re: Table and PHP scripts for existing data
    ... >2) once the table is created inside my database on MySQL, ... >load the data in? ... DELETE query"); ... ("Invalid DATA LOAD query"); ...
    (comp.lang.php)