June 6, 200916 yr Greetings all; In the Database i have a Field called "Wholesale ID". using the product 3322 for example there are two enteries in the field Called "3322" and "3322X" 3322X is the Plus Size selection of the Lingerie. There is also the Manafacture called "Dreamgirl" What i would like to know is if it is possible for the field called "Plussize" to do a calculation to see if there is another entery in the database with the Wholesaler ID = "Wholesaler ID" & X so for example on the record with the wholesaler ID of "3322" it would search to see if there is a record with the Wholesaler ID = "3322X". If there is it returns "Yes" if Not it returns "No". I just need help on the calculation for finding a Value on another record. If (************;"Yes";"No")
Create an account or sign in to comment