Showing a blank field if no data matches up

cathy21406

New member
Local time
Today, 12:24
Joined
Nov 18, 2009
Messages
1
I am a novice at Access so please bear with me.When pulling in two tables in thru query, is there a way to have a blank or n/a or something appear space appear on a line as opposed to it just skipping over that one so all lines have info associated with it? For example we pull in phone numbers and if there is not a phone number associated it would show as blank
 
Not sure exactly what you're getting at from your description (post your query), but one of the following scenarios may solve your problem;

1. You can replace a field with something else using iif(expression, show if true, show if false) eg. iif(phone_number = '' or phone_number is null, 'na', phone_number)
http://www.techonthenet.com/access/functions/advanced/iif.php

2. If you're using an inner join you can only return records where the related field value is in both tables. To return fields as null from the second table, use a left join
 
While in query design view double click on the join between tables and select show all record from table 1 (this is your table name)
 

Users who are viewing this thread

Back
Top Bottom