Invalid Argument In Make Table Query

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

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
 
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

Jerry Whittle said:
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.

zyus said:
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
Click to expand...
Click to expand...
 
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.


zyus said:
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

Jerry Whittle said:
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.

zyus said:
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
Click to expand...
Click to expand...
Click to expand...
 
Back
Top