access2010
Registered User.
- Local time
- Today, 15:20
- Joined
- Dec 26, 2009
- Messages
- 1,118
We are using off premise programers and want to change the data that they receive
Query_Numeric
Change data in the field customer "Credit_Card_No"
from=to 1=3 / 4=6 / 7=9 / 0=2
Query_Alpha
Change data in the field customer "Contact"
from=to A=D / C=F / G=J / K=M / P=S / T=B
Could I please receive a suggestion on how to run both queries.
Thank you
Query_Numeric
Change data in the field customer "Credit_Card_No"
from=to 1=3 / 4=6 / 7=9 / 0=2
Query_Alpha
Change data in the field customer "Contact"
from=to A=D / C=F / G=J / K=M / P=S / T=B
Could I please receive a suggestion on how to run both queries.
Thank you