Recent content by semaj21

Sorry BOB but there is a problem when you enter the numbers between say 4 to 9 ACCESS returns an error, it recognises all the other numbers as correct. I entered the rule as you said i.e "NA" Or Between "0" And "28". The only way to get it to work for me was to type it in as, LIKE "NA" OR "0"...

Thanks works a treat Barry

Thanks for your help. Does that mean I would have to type in say LIKE "NA" OR "0" OR "1" OR "2" OR "3" and so on or do you know of a simpler way to do it. Regards Barry

Yes it is Text

Hello can anyone help me I am trying to make a validation rule for a field. It needs to be Between 0 And 28 OR "NA". When I use this in the validation property it works for the numbers and text but if you input say NJ or any other combination it issues a message box saying cannot evaluate the...

Complex query Hello RJN Thanks for taking an interest. I have created a Union query which does the job of combining the two tables and keeps the data on different lines, the problem I now have is when I try to link the Union query with the two other tables I get a mismatch error from access...

I have three tables called, Clients basic details, Episode and Modality. There are some 56 fields in these tables. Once a month I run a query on these tables. The data is then uploaded to another site via the internet. I have now been asked to collect data into another table called TOPS which...