Hello,
I'm currently stumped and am hoping someone can help me.
I have a query with 38 fields which I pull together data to Create a Table. When I put the query into Select mode, it runs fine with no errors, but when I switch it to Make Table mode, I get the following error (see attachment for a pic). It's as though Access thinks that I'm trying to update an existing table and the field types aren't compatible.
However, since I'm making a new table, all of the fields for the new table are supposed to inherit the field properties of the fields used in the query to make the table.
Can somone look at this and help give me some direction on what might be causing it?
Thank you so much in advance!
I'm currently stumped and am hoping someone can help me.
I have a query with 38 fields which I pull together data to Create a Table. When I put the query into Select mode, it runs fine with no errors, but when I switch it to Make Table mode, I get the following error (see attachment for a pic). It's as though Access thinks that I'm trying to update an existing table and the field types aren't compatible.
However, since I'm making a new table, all of the fields for the new table are supposed to inherit the field properties of the fields used in the query to make the table.
Can somone look at this and help give me some direction on what might be causing it?
Thank you so much in advance!