- Local time
- Today, 17:05
- Joined
- Jan 23, 2006
- Messages
- 15,379
Try these queries.
Create a new query, go to sql view and add this
1:For CustomerContacts
2: Repeat for VendorContacts
For consideration: Based on the recent database(post #19), it seems you are not experienced with Access or vba. Or else you have provided a database that does not match the requirement you stated or we have responded to.
Your sample data is insufficient to test the functions/responses being offered.
When doing data verification/reformatting do it as close to source as possible. That is do it once, not in every form, report etc.
Also, use sql or vba, not input mask.
Good luck with your project.
Create a new query, go to sql view and add this
1:For CustomerContacts
Code:
SELECT Customer_Contacts.Contact, StrConv(Contact,3) AS Customer_Contact_Pc
FROM Customer_Contacts;
2: Repeat for VendorContacts
Code:
SELECT Vendor_Contacts.Contact, StrConv(contact,3) AS Vendor_Contact_PC
FROM Vendor_Contacts;
For consideration: Based on the recent database(post #19), it seems you are not experienced with Access or vba. Or else you have provided a database that does not match the requirement you stated or we have responded to.
Your sample data is insufficient to test the functions/responses being offered.
When doing data verification/reformatting do it as close to source as possible. That is do it once, not in every form, report etc.
Also, use sql or vba, not input mask.
Good luck with your project.
Last edited: