Search results

Hi I am trying to work with a large table of customer data. I know that there is a large number of invalid values. I would like to run a make table query that would check the phone number against a table of known invalid numbers (e.g. 1234567, 11111111, 99999999, etc). If the number exists on...

Hi I have a large file where I am trying to clean up the data. One of the fields is the email address. I want to check if the email address has something followed by an @ symbol followed by something else. If it does not, then I want to replace it with a null value. Can you help? I thought that...

Hi I have a table that contains telephone numbers. The data is in a variety of formats. Here are some examples: 087 123456 087-123456 (W)087-123456 (H)123456 I would like to strip out hyphens, brackets, spaces, etc. I hope to do this in a straighforward make table query. Is there a function...

Hi I am fairly new to this so please help. I have 2 tables such as MEMBER TABLE Member Number Name Address Member Type (Char 1) MEMBER TYPE TABLE Member Type (Char 1) Type Description In the data entry form for the Member Table, I would like to provide a drop down of the possible member...

Hi I have been asked by my tennis club if I could set up a small Access database to help with membership registration and fee collection. Ideally, it would go on to record coaching sessions for juniors, etc but that can come later. Does anybody have a template that I could use as a basis for...