Invalid argument?

[Hendrix10]

I created a database that is linked to tables on a network. I was
trying to run a query to make a table out from the information that I
needed but I keep getting an error message stating invalid argument
error. So, I tried a "make a table" query with the all the fields in
the table but not putting in any filters but still got the "invalid
argument" error. What have i been doing wrong? Am I missing something?

 

[Klatuu]

Please post the code you are using to try to do this.

 

[Hendrix10]

I'm not using any code. I just simply start a new query in design view
and select all the fields and click on the make a table icon. from
there I click on the run icon and get the invalid argument error
message.

 

[Klatuu]

Open the query in design view, switch to SQL view. That is the code I am
asking about. Please post that.

 

[Hendrix10]

Here is the code

SELECT dbo_FN_FCT_DATA.LOAD_ID, dbo_FN_FCT_DATA.LOAD_TYPE,
dbo_FN_FCT_DATA.PROCESS_DATE, dbo_FN_FCT_DATA.VTD_DATE,
dbo_FN_FCT_DATA.SSN, dbo_FN_FCT_DATA.PLAN_TYPE,
dbo_FN_FCT_DATA.ER_NUMBER, dbo_FN_FCT_DATA.FUND_CODE,
dbo_FN_FCT_DATA.UNITS, dbo_FN_FCT_DATA.UNIT_VALUE,
dbo_FN_FCT_DATA.AMOUNT, dbo_FN_FCT_DATA.TRANS_CODE,
dbo_FN_FCT_DATA.TRANS_QUALIFIER INTO [TVI 03]
FROM dbo_FN_FCT_DATA
WHERE (((dbo_FN_FCT_DATA.LOAD_TYPE)="tvi") AND
((dbo_FN_FCT_DATA.PROCESS_DATE)>#12/31/2001# And
(dbo_FN_FCT_DATA.PROCESS_DATE)<#1/1/2003#));

 

[Klatuu]

I don't see any problem with the query.
--
Dave Hargis, Microsoft Access MVP

Here is the code

SELECT dbo_FN_FCT_DATA.LOAD_ID, dbo_FN_FCT_DATA.LOAD_TYPE,
dbo_FN_FCT_DATA.PROCESS_DATE, dbo_FN_FCT_DATA.VTD_DATE,
dbo_FN_FCT_DATA.SSN, dbo_FN_FCT_DATA.PLAN_TYPE,
dbo_FN_FCT_DATA.ER_NUMBER, dbo_FN_FCT_DATA.FUND_CODE,
dbo_FN_FCT_DATA.UNITS, dbo_FN_FCT_DATA.UNIT_VALUE,
dbo_FN_FCT_DATA.AMOUNT, dbo_FN_FCT_DATA.TRANS_CODE,
dbo_FN_FCT_DATA.TRANS_QUALIFIER INTO [TVI 03]
FROM dbo_FN_FCT_DATA
WHERE (((dbo_FN_FCT_DATA.LOAD_TYPE)="tvi") AND
((dbo_FN_FCT_DATA.PROCESS_DATE)>#12/31/2001# And
(dbo_FN_FCT_DATA.PROCESS_DATE)<#1/1/2003#));

Open the query in design view, switch to SQL view. That is the code I am
asking about. Please post that.
--
Dave Hargis, Microsoft Access MVP








- Show quoted text -

 

[Hendrix10]

I don't see any problem with the query.
--
Dave Hargis, Microsoft Access MVP

Here is the code

SELECT dbo_FN_FCT_DATA.LOAD_ID, dbo_FN_FCT_DATA.LOAD_TYPE,
dbo_FN_FCT_DATA.PROCESS_DATE, dbo_FN_FCT_DATA.VTD_DATE,
dbo_FN_FCT_DATA.SSN, dbo_FN_FCT_DATA.PLAN_TYPE,
dbo_FN_FCT_DATA.ER_NUMBER, dbo_FN_FCT_DATA.FUND_CODE,
dbo_FN_FCT_DATA.UNITS, dbo_FN_FCT_DATA.UNIT_VALUE,
dbo_FN_FCT_DATA.AMOUNT, dbo_FN_FCT_DATA.TRANS_CODE,
dbo_FN_FCT_DATA.TRANS_QUALIFIER INTO [TVI 03]
FROM dbo_FN_FCT_DATA
WHERE (((dbo_FN_FCT_DATA.LOAD_TYPE)="tvi") AND
((dbo_FN_FCT_DATA.PROCESS_DATE)>#12/31/2001# And
(dbo_FN_FCT_DATA.PROCESS_DATE)<#1/1/2003#));

- Show quoted text -

Could it be anything else?

 

[Klatuu]

Sorry, I have no idea. I suggest you repost your question in the Queries
group and post the SQL along with it. Perhaps someone else will see what I
can't.
--
Dave Hargis, Microsoft Access MVP

I don't see any problem with the query.
--
Dave Hargis, Microsoft Access MVP

Here is the code

SELECT dbo_FN_FCT_DATA.LOAD_ID, dbo_FN_FCT_DATA.LOAD_TYPE,
dbo_FN_FCT_DATA.PROCESS_DATE, dbo_FN_FCT_DATA.VTD_DATE,
dbo_FN_FCT_DATA.SSN, dbo_FN_FCT_DATA.PLAN_TYPE,
dbo_FN_FCT_DATA.ER_NUMBER, dbo_FN_FCT_DATA.FUND_CODE,
dbo_FN_FCT_DATA.UNITS, dbo_FN_FCT_DATA.UNIT_VALUE,
dbo_FN_FCT_DATA.AMOUNT, dbo_FN_FCT_DATA.TRANS_CODE,
dbo_FN_FCT_DATA.TRANS_QUALIFIER INTO [TVI 03]
FROM dbo_FN_FCT_DATA
WHERE (((dbo_FN_FCT_DATA.LOAD_TYPE)="tvi") AND
((dbo_FN_FCT_DATA.PROCESS_DATE)>#12/31/2001# And
(dbo_FN_FCT_DATA.PROCESS_DATE)<#1/1/2003#));

Open the query in design view, switch to SQL view. That is the code I am
asking about. Please post that.

:
I'm not using any code. I just simply start a new query in design view
and select all the fields and click on the make a table icon. from
there I click on the run icon and get theinvalidargumenterror
message.

Please post the code you are using to try to do this.

:
I created a database that is linked to tables on a network. I was
trying to run a query to make a table out from the information that I
needed but I keep getting an error message statinginvalidargument
error. So, I tried a "make a table" query with the all the fields in
the table but not putting in any filters but still got the "invalid
argument" error. What have i been doing wrong? Am I missing something?- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -

Could it be anything else?