Recent content by amberjen

hello, I have a field that contains digits and text. the text is "x". I want to create a query to show is the digits after the "x". Could someone help?:confused: example: field 1: xxxx-1234 or xxxxxxx256

@plog - I created a query to generate the 3 fields from 3 different tables (that's was the easy part). These 3 tables have the account number listed as I shown in the fields, I need to make sure they match to field 1. I was thinking doing a string to have query match any right of # from field...

Hello everyone, I'm a novice with Access. I been searching this forum and YouTube to help with this project I'm trying to complete for work but hit :banghead::banghead: BIG time. I hope someone can HELP ME.. Lots of ideas is going in my head and did a several test query getting very...

Hello, I'm a novice Access user. I started reading some of the post on Access World Forum and learn a great deal from everyone! Thank you. AJ