473,503 Members | 1,705 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Message to show on customers with no orders on Access

4 New Member
Hello! I am doing a continuous report based on customers and the orders they have placed. I have to include all customers whether or not they have placed orders. I also have to include a message saying that the customer placed no orders. I've been struggling with this concept. How do I include the message? Thanks!
May 9 '18 #1
3 1559
NeoPa
32,557 Recognized Expert Moderator MVP
You start with a query where your customer table is linked with a LEFT JOIN to your orders table. A LEFT JOIN will mean that all fields from the orders table are represented as Null.

Now comes the easy part. Use Nz() to show either the linked value if it exists, or the message if the value is Null.
May 9 '18 #2
Disneygirl25
4 New Member
It worked! Thank you so much!
May 13 '18 #3
NeoPa
32,557 Recognized Expert Moderator MVP
It's a pleasure to help where I can :-)
May 13 '18 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

4
2131
by: MLH | last post by:
Is it possible for me to open, read and display a specific eMail message from within an Access database? Perhaps I have received an eMail from a customer in the customers table that I wish to save...
8
2020
by: Charles | last post by:
Can anyone help me with this error. "Could not access 'CDO.Message' object." This is from the: "SmtpMail.Send(mailMsg)" command.
4
1211
by: bildo | last post by:
I just installed SQL 8.0, IIS, Visual Studio on XP Pro laptop. I installed VS Books samples from book cd and ran SQL & Access DB samples on the browser just fine. Got the right results. I took...
0
1940
by: neeraj | last post by:
Hi Everybody I have one problem in my asp.net web application. The problem is that I check the date validation in code behind; if user not gives the valid data and press save button then I fire...
5
1293
by: havana7 | last post by:
I need an invoce-customers-orders example application to know what is the best way to use C# in that context. Is there anything on the web? Do you know some links to download source? Thanx to...
24
3674
by: jerrydigital | last post by:
Hello, I am new to this forum but have read several posts and I thank you for your great assistance. I am stumped right now. I have a user registration form in asp that is set to a form...
1
8060
by: parmsingh | last post by:
I am trying to use CDO to send email with attachments using the following code: Dim myMail Dim mFile1 mFile1="c:\images\a.gif" 'valid file path, file actually exists Set...
0
1165
by: jayamalini | last post by:
I have a page which has a pop up page. the pop up page should be visible only for external customers. when the main page loads, internal customers within an ip range should not get the pop up page, I...
1
1734
by: coding master | last post by:
Hello how i message show, when session expired? without web.config i am working on visual Studio 2008(3.5)
0
671
elenaA
by: elenaA | last post by:
Hello i have one question. is it posible to show only quick access bar in the ms access ? for now i locked navigation panel, i know to locked the menus. i want now to show only quick...
0
7202
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
7086
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
7280
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
1
6991
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
7460
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
4672
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
0
1512
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...
1
736
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
380
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.