Format I want data to appear in in a listbox

[david.paton]

I have a listbox on a form and I want it to return names and numbers. I want the numbers to be in a certain format instead of just one string. The format I want is:


Phone: (xx) xxxx xxxx
Mobile: xxxx xxx xxx



The form I want that for is frmRespiteNAvailable

Thanks,
Dave

 

[isladogs]

Add formatting to the 2 fields in the listbox SQL

SELECT qryCarerRespiteCareNAvailable.CarersFirstName, qryCarerRespiteCareNAvailable.CarersLastName, Format([CarersPhone],"(00) 0000 0000") AS Carers_Phone, Format([CarersMobile],"0000 000 000") AS Carers_Mobile
FROM qryCarerRespiteCareNAvailable
ORDER BY qryCarerRespiteCareNAvailable.CarersLastName;

See attached

 

[david.paton]

Add formatting to the 2 fields in the listbox SQL

SELECT qryCarerRespiteCareNAvailable.CarersFirstName, qryCarerRespiteCareNAvailable.CarersLastName, Format([CarersPhone],"(00) 0000 0000") AS Carers_Phone, Format([CarersMobile],"0000 000 000") AS Carers_Mobile
FROM qryCarerRespiteCareNAvailable
ORDER BY qryCarerRespiteCareNAvailable.CarersLastName;

See attached

That was perfect, thanks