Quote:
Originally Posted by 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]
I would like to help, but I am a little confused.
- Post some sample data that you are Importing, and the code you use to Import it with.
- Post what you would like the final results to be.
- What is your Validation Criteria for each Field.
- What happens if a Field does not pass the Validation?
- Please provide any other information that you think is relevant.
