"No Current Record" question

[vincentt via AccessMonster.com]

Hi all,

I have a multi-table query, link to the following table:

order table
client info table
receipt table
discount card table

I want to query multiple fields in the above table. Normally, I have to enter
client info, while they place an order and have a receipt, so the first 3
tables contain data. However, for the discount card table, it would only be
given to some specific clients, so it may not be compulsory. But he foreign
key for the table is the order id.

So, in the query, if the discount card table contains no data, that client
would disappear in the query.

I really want to query all the field together in one query, but not separate
into 2.

Please give a light on it. Thanks in advance!

--
I am so new to Access... questions questions and questions...

Thanks always!

Message posted via http://www.accessmonster.com

[NthDegree]

Open your query, select SQL view, find the text "INNER JOIN discount card
table" and change it to "LEFT JOIN discount card table"

"vincentt via AccessMonster.com" <u20211@uwewrote in message
news:652eddc51722a@uwe...

Hi all,

I have a multi-table query, link to the following table:

order table
client info table
receipt table
discount card table

I want to query multiple fields in the above table. Normally, I have to
enter
client info, while they place an order and have a receipt, so the first 3
tables contain data. However, for the discount card table, it would only
be
given to some specific clients, so it may not be compulsory. But he
foreign
key for the table is the order id.

So, in the query, if the discount card table contains no data, that client
would disappear in the query.

I really want to query all the field together in one query, but not
separate
into 2.

Please give a light on it. Thanks in advance!

--
I am so new to Access... questions questions and questions...

Thanks always!

Message posted via http://www.accessmonster.com