Query with concatenated fields - Access Developer Forum


	Back to Access Developer Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Query with concatenated fields

Simon Levesque

3 years ago

I have a query with 3 concatenated fields. Everything runs ok but when 1 of the 3 concatenated fields has no value, the entire record doesn't show in my continuous form, any ideas?

	Kevin Robertson @Reply 3 years ago
Can you post a screenshot of your Query clearly showing the concatenated field. Without actually seeing what you are doing makes it very difficult to troubleshoot.

	Simon Levesque OP @Reply 3 years ago
Do you want to see all the query because its a very big one or maybe just the sql statement?

	Simon Levesque OP @Reply 3 years ago
I speak French so sorry if you have trouble understanding some field names!!

	Kevin Robertson @Reply 3 years ago
Are these fields from more than one Table? You may have to change your Join Types. Outer Joins

	Simon Levesque OP @Reply 3 years ago
No, each concatenated field is made from fields from one table

	Simon Levesque OP @Reply 3 years ago
outer joins it was!! Thank you so much!

	Kevin Robertson @Reply 3 years ago
Glad to help.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Developer Forum.

Next Unseen

New Feature: Comment Live View