Queries

I am getting so fustruted I am trying to run a query and at first it tried to tell me to change the memo section, so I did. The thing is none of my tables to me are not relating. Every time I try to run anything especially a query, I get some kind of message.
Someone please help, I have done this before and something seems to be very wrong.
P.S. I have created it from scratch.
Thanx
Jami

On Mon, 7 Jun 2004 15:36:03 -0700, "Jami"
wrote:

I am getting so fustruted I am trying to run a query and at first it tried to tell me to change the memo section, so I did. The thing is none of my tables to me are not relating. Every time I try to run anything especially a query, I get some kind of message.
Someone please help, I have done this before and something seems to be very wrong.
P.S. I have created it from scratch.
Thanx
Jami

Jami, you'll have to give us some help here. There is clearly
something wrong with your query, but since we cannot see your database
and you have not given us any information about the tables, how you
are trying to relate them, or the nature of the query it's impossible
to say much.

One speculation: if you're trying to join two tables on a Memo field,
don't - it won't work (and with the usual uses of a memo field it
wouldn't be a sensible thing to do anyway).

What are your Tables?
What are their Fields?
How are you trying to link them?
WHat error messages are you getting?
And most importantly, could you open the Query in SQL view and post
the SQL text here?

John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public