Adding a combo box to a query

[Joceline]

hi,

I'm trying to write a query from a table that has a combo box. I want to have the information in the combo box added to the AS NAME so that i have first name, last name and then their designation all in one. I'm able to have the first and last name group, but I can't seem to add the designation because it's a combo box.

Does anyone know how to fix this? Any suggestions would be great!!
Thanks.

 

[jdraw]

Show us a picture of your tables and relationships and/ or some SQL so we understand.


Do you have Lookups at the Table level?
http://access.mvps.org/access/lookupfields.htm

 

[Joceline]

hi,

here is the SQL that i currently have: SELECT [TBLContactDetails.strcontactdetailsFirstName] & " " & [TBLContactDetails.strcontactdetailsLastName] AS NAME, tblContactdetails.strcontactdetailsDesignation, tblGroupDetails.strGroupdetailsdescription, tblContactGroupsjunction.[strcontactgroupRole In Group]

because the designation is a combo box, I can't add it to the AS NAME section.

does this help?

 

[jdraw]

In plain English what are you trying to do?

Have you seen this
http://office.microsoft.com/en-ca/a...bo-box-or-drop-down-list-box-HP005187786.aspx

or these

http://www.techonthenet.com/access/comboboxes/

 

[Joceline]

hi,
i was able to figure out how to make it work. Now i would need to create a script that will have all of my address information such as address, city, province, postal code and phone numbers as one.

any ideas?

really appreciate your taking the time to help me out. i promise one day when i'm good at this, i'll pass it forward!!

 

[vbaInet]

Having it as one... meaning? Please expand.

 

[Joceline]

yes, i would like to have my address show on "one line" for a report i'm trying to create! if you have any suggestions, they would be welcomed.

thanks for replying.

 

[vbaInet]

You can concatenate the addresses like this:

[Address] & " " & [City] & " " & [Province] & " " & [PostalCode]

try it out in a query.

 

[Joceline]

perfect! that works beautifully.

do you know how to add the Null if there are empty fields?

 

[vbaInet]

You mean how to get rid of the extra space if a field is empty?

 

[Joceline]

yes! what would i need to add to the script to accomplish this?

 

[vbaInet]

See what you can come up with. Have a read:

http://office.microsoft.com/en-us/a...alues-by-using-an-expression-HA010235851.aspx

It's called Null Propagation.

 

[Joceline]

thanks! this is a great article. i'm fairly new at this database stuff and trying to learn most of it on my own.

you've been a great help!!

have a great day!

 

[vbaInet]

Glad we could help.