I am creating a database that will hold customer information and order information. I want to create a unique customer id using the first 3 letters of the last name and the last 3 letters of the first name. Can this be done if so how? Any help would be great.
JJ
All I have created an edit records query and an edit anwser query so people can edit answers to various questions once they have been entered. I have created 2 forms and the associate opens the Edit Answer form by clicking on a command button. This works great. However when they changes they...
I have built several queries to count the number time yes is checked for a line item. When I run the individual query it works perfectly. I want a report of the combined queries. When I combined the queries the data no longer displays. Can someone please help me figure this out. Below is...
I have built a query that counts the number of Associates that are under a supervisor. The query works great but I want to build an expression to take the total number of associates and multiply them by 10. Does anyone know how to accomplish this. Any help you can provide would be great.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.