Validating Data within the form

[Guest]

Good morning to all,

I have a form that with a subform. The main form has Customer Information,
but the sub form has Specialist information.

There are Validation that need to be established so that there is no
duplication of data.

the Fields are;

ShowData - Date/Time
SKU - Text
AssociateID - Text
DateFirstSold - Date/Time
DateEntered - Date/Time

What I need to Validate are:

1. SKU cannot be shown more than once within a 13 week period from the
DateFirstSold

2. There cannot be more than 1 Associate ID Assigned to this account with
this product. (First Come First Serve!)

if anyone has something simular or can direct me with the right coding that
would be greatly appreciated.

 

[Guest]

Hi TheNovice,

I would create a query that includes all the fields listed, and then look
at the DateDiff function in help and use with the "q" (quarter) parameter to
find other sku's within the given time frame, and then the DCount function to
find out if any current records share the same AssociateID.

Post back any coding you can't get to work as you hoped!

TonyT..

 

[Guest]

Thanks TonyT,

what I was looking for was if someone already had such a function. I can
query it to find the inconsistancy in the days, but i was not sure if I could
get it to work with two criteria...