By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,960 Members | 1,009 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,960 IT Pros & Developers. It's quick & easy.

"No Current Record" question

P: n/a
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

Aug 23 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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

Aug 31 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.