Invalid Arguement

[Guest]

I am trying to append two tables together and I keep getting an invalid
arguement. I have made sure that all the data types match and all headings
are the same.

I have appended several other tables to this same table. It took me forever
because I kept getting invalid arguements. I got it to work by just trying
day after day, sometimes it would give me an error and sometimes it wouldnt.

Any possible clues as to what could be the issue.

 

[Ken Snell [MVP]]

Hard to say without any info about the query's SQL, the tables' designs,
etc.

Offhand, my first guess is that you're using a function in the query and an
argument for the function has a Null value, and the function is choking on
that argument.

 

[John Vinson]

I am trying to append two tables together and I keep getting an invalid
arguement. I have made sure that all the data types match and all headings
are the same.

I have appended several other tables to this same table. It took me forever
because I kept getting invalid arguements. I got it to work by just trying
day after day, sometimes it would give me an error and sometimes it wouldnt.

Any possible clues as to what could be the issue.

Care to post the SQL of your query and a description of the table
fields?

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps