Subscript out of range

The above error message occurs when I try to build a query. The strange part
is that I have built several queries using the same two tables in the past
without this error occurring.
My database is used on a LAN with the tables residing on the server.When
convert back to a stand alone database this error does not appear.

Any ideas as to why this is happening "all of a sudden"

Thanks

Thanks Ken. Your response made me think a little more about this.I tried
again to create a query, using the wizard,with two fields from two separate
tables and received the same error message. Tried again with the same fields
but no wizard and didn't receive an error. Can't post the SQL 'cos I can't
get thru the wizard to complete the query. At least can work around the
wizard but as I said initially I have devised queries before with no problem
utilizing the same two tables.

Regards

"Ken Snell (MVP)" wrote in message
...
Nearly impossible to even guess without knowing anything about the query's
SQL statement. Can you post that?

--

Ken Snell
MS ACCESS MVP

"Tee See" wrote in message
.. .
The above error message occurs when I try to build a query. The strange
part is that I have built several queries using the same two tables in
the past without this error occurring.
My database is used on a LAN with the tables residing on the server.When
convert back to a stand alone database this error does not appear.

Any ideas as to why this is happening "all of a sudden"

Thanks