I am working with Microsoft Access and got stuck on one of the directions. My problem is that I can't write the
correct expression for the following:
Open the Missing Addresses query in Design view. Add a new column to determine if a customer does not have an address on file. If the customer's Address is null, it should display Missing. If not, it should display nothing. Name the column AddressPresent. Add criteria of Missing to the column you just created, so only the customers missing an address display. Move the AddressPresent field so it appears between PhoneNumber and Address. Run the query. Ensure only customers with null Address fields display. Save and close the query.
Thank you in advance.
Recently Asked Questions
- Please refer to the attachment to answer this question. This question was created from 188.8.131.52 Lab - Flex Sensor and Servo.pdf.
- Hello, Can I please get some help on how to solve a few of these.
- What are the pros and cons of these application/software? Windows RDP RemotePC TeamViewer TigerVNC Windows VPN access NordVPN OpenVPN ProtonVPN