Inconsistent Query Error...

[DHavokD]

Okay so background, I have four tables of data in a similar structure. I have four queries to combine the data into the form I need, the first is a Make-Table then the other three are Appends (to the table).

They all have basically identical structure to start and use the exact same code, etc to get the job done. But for some reason one of the three Append Queries throws an error:

"This expression is typed incorrectly, or it is too complex to be evaluated. For example, a numeric expression may contain too many complicated elements. Try simplifying the expression by assigning parts of the expression to variables."

The weird thing is that all three of the Append Queries do the EXACT SAME THING.



Any help would be great, this problem has persisted for a few days and is getting annoying, I just keep putting off, ignoring that list.

[RuralGuy]

I have a couple of questions. Why not just use a select query instead of a MakeTable query? Why do you have several tables with the same structure? Wouldn't one do with an extra field if need be to tell you where the record came from?

[DHavokD]

Well each table comes from a different one of our websites, and yes there is a field added to distinguish where it came from.

[RuralGuy]

Could you have a data issue? Maybe you have some incorrect data in one of the fields? Are you using a MakeTable query or an Append query?

[DHavokD]

The one that is throwing the error is an Append Query, and I was thinking it may be a data issue but my boss is like no that is dumb...

[DHavokD]

OMG I combed through that table for an hour yesterday and found nothing... So I try again in hopes I will come accross something. BOOM! Stupid #NUM! error on a calculated field.

Thanks for the help!

[RuralGuy]

Alright!!! Way to go!!! Is this thread now solved?

[DHavokD]

Marked as solved.

[RuralGuy]

Outstanding! Thanks.