Hey guys, thanks to you all for the feedback. Will have to go and try out the different suggestions.
@zmbd i have a work in progress database that i have for a business and need to have it show the name of company (1st letter of the two names = XX and then the product name = TCT) bearing in mind the product name will be various lengths. I would send the file but is large and still incomplete, going thro it as i find errors.
Thanks...
Ms2BSwagg
Last Activity: Jun 24 '15, 01:05 PM
Joined: Jun 19 '15
Location:
-
MS Access - Query Help
Hi,
I Need to show a product code with a unique entry in a table.
Eg – Xxxxx Xxxx – Thai Chocolate Tea = XX-TCT
Regards -
Hey Seth,
Thank you for the response.
Something so simple hahhaha.
RegardsLeave a comment:
-
MS Access Table Query showing Customer Name as a code.
HI,
I would like to show the 1st 5 characters of Customers First and Last Name combined into one field.
Eg John Snow = SnowJ
Thanks in advance.
No activity results to display
Leave a comment: