Search results

The *@* criteria does not appear to be working for me. I was putting in <>"*@*" is this correct. What I am intending is that the field is not equal to anything followed by an @ followed by anything? Noel

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...

Thanks Looks like I have generated a bit of heat on this one. Thanks everybody for your help. Noel

Hi Thanks for the feedback on using a combo box. However, how would I use a combo box that looks up another table to find the valid values? Regards Noel

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...