Hi! Help me with my problem please!!!

[Keidy]

Hi! I forgot completely how to join two fields of a table in one listbox, TAG and Equipment, i want to join them, but they have together separated by a comma or a space on a list box... could you help me?

 

[Jonathan Kok]

I'm assuming you're getting the values out of a table via a query.

In the source query, 'create' your own field with the following:
Fieldname: [TAG] & ", " & [Equipment]

 

[Keidy]

thanks

thanks a lot, sorry for not being very clear, that's because i speak spanish. can you explain me how to do it but in SQL. It would be very nice and kind of you

I'm assuming you're getting the values out of a table via a query.

In the source query, 'create' your own field with the following:
Fieldname: [TAG] & ", " & [Equipment]

 

[Jonathan Kok]

SELECT [TAG] & ", " & [Equipment] AS fieldname FROM tablename;

 

[Keidy]

Another Question

i have another question about that, if i want to create a field with that information but in the same table what do i have to do?

SELECT [TAG] & ", " & [Equipment] AS fieldname FROM tablename;

 

[Jonathan Kok]

1. Create the field in the table.
2. Add the field to your form.
3. Convert the field to a 'combo box'. This should bring up the wizard. Cancel it.
4. Set the source of the combobox to Table/Query, and put your SQL in the source box. Though you might get more mileage from using 'SELECT DISTINCTROW [TAG]....' instead.