Invalid Argument In Make Table Query

[Guest]

I can get my data without error when i run select query but when i run a make
table query i got "invalid Arguement"

This is my SQL view of my query

SELECT [tbl-SKS CIF].CIFIDNO, [tbl-SKS ACCT].ACCTIDNO, [tbl-SKS
ACCT].ACCTLNAME, [tbl-SKS ACCT].ACCTBRNCD, [tbl-SKS ACCT].ACCTMODCD, [tbl-SKS
ACCT].ACCTACNO, [tbl-SKS ACCT].ACCTCHKDGT, [tbl-SKS ACCT].ACCTPRLINE,
[tbl-SKS ACCT].ACCTPRTYP, [tbl-SKS ACCT].ACCTMTHIST, [tbl-SKS
ACCT].ACCTACSTS, [tbl-SKS ACCT].ACCTOLDIDNO, [tbl-SKS CIF].CIFOLDIDNO,
[tbl-SKS CIF].CIFNAME
FROM [tbl-SKS CIF] INNER JOIN [tbl-SKS ACCT] ON [tbl-SKS CIF].CIFOLDIDNO =
[tbl-SKS ACCT].ACCTOLDIDNO;


Appreciate your help & advice

Thanks

 

[Guest]

Thks for yr reply.....but still got the same invalid error (Follow ur SQL
below)..Is it due to some null field in my CIFOLDIDNO and ACCTOLDIDNO?

Thks

Please post the SQL of the attempted make table query. Your select statement
looks straight forward and the make table should also. It should look
something like this:

SELECT [tbl-SKS CIF].CIFIDNO,
[tbl-SKS ACCT].ACCTIDNO,
[tbl-SKS ACCT].ACCTLNAME,
[tbl-SKS ACCT].ACCTBRNCD,
[tbl-SKS ACCT].ACCTMODCD,
[tbl-SKS ACCT].ACCTACNO,
[tbl-SKS ACCT].ACCTCHKDGT,
[tbl-SKS ACCT].ACCTPRLINE,
[tbl-SKS ACCT].ACCTPRTYP,
[tbl-SKS ACCT].ACCTMTHIST,
[tbl-SKS ACCT].ACCTACSTS,
[tbl-SKS ACCT].ACCTOLDIDNO,
[tbl-SKS CIF].CIFOLDIDNO,
[tbl-SKS CIF].CIFNAME
INTO tblMakeTable
FROM [tbl-SKS CIF] INNER JOIN [tbl-SKS ACCT]
ON [tbl-SKS CIF].CIFOLDIDNO = [tbl-SKS ACCT].ACCTOLDIDNO ;
--
Jerry Whittle
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

I can get my data without error when i run select query but when i run a make
table query i got "invalid Arguement"

This is my SQL view of my query

SELECT [tbl-SKS CIF].CIFIDNO, [tbl-SKS ACCT].ACCTIDNO, [tbl-SKS
ACCT].ACCTLNAME, [tbl-SKS ACCT].ACCTBRNCD, [tbl-SKS ACCT].ACCTMODCD, [tbl-SKS
ACCT].ACCTACNO, [tbl-SKS ACCT].ACCTCHKDGT, [tbl-SKS ACCT].ACCTPRLINE,
[tbl-SKS ACCT].ACCTPRTYP, [tbl-SKS ACCT].ACCTMTHIST, [tbl-SKS
ACCT].ACCTACSTS, [tbl-SKS ACCT].ACCTOLDIDNO, [tbl-SKS CIF].CIFOLDIDNO,
[tbl-SKS CIF].CIFNAME
FROM [tbl-SKS CIF] INNER JOIN [tbl-SKS ACCT] ON [tbl-SKS CIF].CIFOLDIDNO =
[tbl-SKS ACCT].ACCTOLDIDNO;

Appreciate your help & advice

Thanks

 

[Guest]

Nulls aren't the problem. If there is a null on either side, no record is
returned.

I'm thinking that you may have a corruption problem. Try doing a compact and
repair.
--
Jerry Whittle
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

Thks for yr reply.....but still got the same invalid error (Follow ur SQL
below)..Is it due to some null field in my CIFOLDIDNO and ACCTOLDIDNO?

Thks

Please post the SQL of the attempted make table query. Your select statement
looks straight forward and the make table should also. It should look
something like this:

SELECT [tbl-SKS CIF].CIFIDNO,
[tbl-SKS ACCT].ACCTIDNO,
[tbl-SKS ACCT].ACCTLNAME,
[tbl-SKS ACCT].ACCTBRNCD,
[tbl-SKS ACCT].ACCTMODCD,
[tbl-SKS ACCT].ACCTACNO,
[tbl-SKS ACCT].ACCTCHKDGT,
[tbl-SKS ACCT].ACCTPRLINE,
[tbl-SKS ACCT].ACCTPRTYP,
[tbl-SKS ACCT].ACCTMTHIST,
[tbl-SKS ACCT].ACCTACSTS,
[tbl-SKS ACCT].ACCTOLDIDNO,
[tbl-SKS CIF].CIFOLDIDNO,
[tbl-SKS CIF].CIFNAME
INTO tblMakeTable
FROM [tbl-SKS CIF] INNER JOIN [tbl-SKS ACCT]
ON [tbl-SKS CIF].CIFOLDIDNO = [tbl-SKS ACCT].ACCTOLDIDNO ;
--
Jerry Whittle
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

I can get my data without error when i run select query but when i run a make
table query i got "invalid Arguement"

This is my SQL view of my query

SELECT [tbl-SKS CIF].CIFIDNO, [tbl-SKS ACCT].ACCTIDNO, [tbl-SKS
ACCT].ACCTLNAME, [tbl-SKS ACCT].ACCTBRNCD, [tbl-SKS ACCT].ACCTMODCD, [tbl-SKS
ACCT].ACCTACNO, [tbl-SKS ACCT].ACCTCHKDGT, [tbl-SKS ACCT].ACCTPRLINE,
[tbl-SKS ACCT].ACCTPRTYP, [tbl-SKS ACCT].ACCTMTHIST, [tbl-SKS
ACCT].ACCTACSTS, [tbl-SKS ACCT].ACCTOLDIDNO, [tbl-SKS CIF].CIFOLDIDNO,
[tbl-SKS CIF].CIFNAME
FROM [tbl-SKS CIF] INNER JOIN [tbl-SKS ACCT] ON [tbl-SKS CIF].CIFOLDIDNO =
[tbl-SKS ACCT].ACCTOLDIDNO;

Appreciate your help & advice

Thanks