Search results

***i have this query....it has a concatenated field ---rs number SELECT dbo_MAIN.DATE, dbo_MAIN.[VISIT FORM NO], dbo_MAIN.[OUTLET NO], dbo_MAIN.NAME2, dbo_MAIN.RATE, dbo_MAIN.REMARKS, _ dbo_MAIN.[CUSTOMER TYPE], ConcatRelated("[RS NUMBER]","[waybill list query]",_ "[OUTLET NO] & [VISIT FORM...

im having problem with my access form condition the first 3 truck pick up rate should be 200 then the Succeeding trucks's rate be 100.....how can do this in code?pls help