display error records concatenat

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Access Training and help » Display error for records concatenated in query statement

Display error for records concatenated in query statement

resolvedResolved · High Priority · Version 2003

Pasquale has attended:
Access Introduction course
Access Intermediate course
Access Advanced course

Display error for records concatenated in query statement

Hello,

I've set-up a query that is meant to display a set of address fields as one record from my contact info table.

The contact info table includes the following field: address1, address2, city and postcode.

The majority of records have information for address1, city and postcode, and a few have the same information plus the address2 field.

I've written the following expression to display the address:

Address: [contact info.address1]+", "+[contact info.address2]+", "+[contact info.city]+" "+[contact info.postcode]

When I run the query the only records that appear are the ones who's address1, address2, city and postcode fields contain information, the other records appear blank.

How can I change the expression so that all Address records are displayed?

RE: Display error for records concatenated in query statement

I'm guessing here that you want to view all the blank records in the tables

Make a copy of that query and try typing the word

Null in the criteria box for the address

That should display blanks.

If it doesn't get back to me

Thanks

RE: Display error for records concatenated in query statement

Hi,

I've tried placing null in the criteria box, but that hasn't worked, the query doesn't list any records.

I've tried the follwing code in the criteria box:

("address2"="address2") Or ("address2"=" ") as well as

("address2"="address2") Or ("address2"="null")

however, both only display the addresses that have text in the address1, address2, city and postcode fields, those with blank fields in the address2 fields are not displayed.

Regards


 

Access tip:

Insert The Current Date

To insert the current date into a Table field or Form Text box use:

Ctrl+Semi-Colon(;)

View all Access hints and tips


Server loaded in 0.08 secs.