Recent content by semaj21

Sorry you must leave out the LIKE statement. Regards Barry

Hello again I have now resolved the issue thanks to a microsoft forum memmber. In the table field validation properties if you set the propertie to read "NA" OR LIKE Between "0" AND "28" the validation works. the quotation marks around the numbers was the key. Thanks for your help. Regards Barry

Sorry if I was misleading, what I meant to say was if someone by error entered NJ or any other text but the required text NA Access returns the constraint error message. Regards Barry

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

Sorry its so confusing Below is the type of data sheet I need i.e. it shows different table data on a new line. This was made by, as you said a UNION Query. My problem is I need to Link this Union query to two other tables in my Database. When I try to Access returns a message saying Data...

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