help with access validation to cannot figure it out

[mikeh]

hi. ive searched the net for days for help hope some one here can help on this.

i am using micosoft access2003.

i have a table where i import fields from seach forms. as i import a field i need it to validate that a specific field ie. [power]=7.00 and that the new field [powerb] is the same as [power] or fit[eight] new field [fitb] to be eight also.

the problem is this is for multiple fields both text and numbers

basically i am combining four records into one and their criteria have to be the same to be grouped together their power, fit, make and model.

i think this has to be done in vb as the table will not allow me to add something as simple as[fitb]=[fit]

[MMcCarthy]

I am moving this to the Access forum.

ADMIN

[ADezii]

hi. ive searched the net for days for help hope some one here can help on this.

i am using micosoft access2003.

i have a table where i import fields from seach forms. as i import a field i need it to validate that a specific field ie. [power]=7.00 and that the new field [powerb] is the same as [power] or fit[eight] new field [fitb] to be eight also.

the problem is this is for multiple fields both text and numbers

basically i am combining four records into one and their criteria have to be the same to be grouped together their power, fit, make and model.

i think this has to be done in vb as the table will not allow me to add something as simple as[fitb]=[fit]

I would like to help, but I am a little confused.

1. Post some sample data that you are Importing, and the code you use to Import it with.
2. Post what you would like the final results to be.
3. What is your Validation Criteria for each Field.
4. What happens if a Field does not pass the Validation?
5. Please provide any other information that you think is relevant.