Yes, that is how city state and zip are in the field. The real problem is the order of these fields.
Name
Company
Address
city, state zip
Name
address
city state zip
over and over again like in labels, but this is not how a dtabase should look. Thanks again.
Thanks for replying. When I created the labels, the contact number was not on them even though they were in the excel file. I will have to type them manually. As for the divisions, it is as follows
Name
Company
Address
City State Zip
And this repeats as labels would. I am trying to get them to...
I created labels from a very large excel database with the format name/company/address/city/state/zip/contact# I printed out the labels and sure enough the next day the hard drive failed. Now I need to find a way to convert the label format into the original format. When I scan the labels it...
I have a query that used to filter clients by the dates they arrived for services. Now I would like to filter by the dates and the person who saw the client, but when I try it, all it does is print out all the clients within the two dates and replaces the person who actually saw them with the...
Ok, let me try again. I have two tables, one is for the permanent information of the client, name address etc. I have a second table, for information when the client visits, such as who their doctor was, their ailment etc. Both tables have the same three values, first name, last name, social...
I see that the question has been asked a million times but I still can't get it. Basically I have two different forms for two separate tables. However, both tables have 3 values that are the same, Firstname, LastName, Social. I am trying to create a one to many relationship by using the two...
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.