Recent content by calvinyoo

Hi ALL, Even though I couldn't get the answer from here, but I managed get help from other forum. Just share with you all what I get: For Effective Rate by Period, should have EffectiveStartDate and EffectiveEndDate Then, in Query, the criteria need show up "<=[TransactionDate]" or...

Hi Jdraw, Thanks for your help. But I still need further helps: We put s simple dates>> Delivery Date is 5 Jan 2015, while A effective date is 1 Jan 2015 and B effective date is 1 Feb 2015. Print Screen link...

Hi, just add more details. for Table of Customer Agreed Transport Rate, four fields are might be repeated. Example, Route (from A to B) Customer A, Rate is USD 1 with Effective Date 1/1/2015. While, Rate is USD 2 with Effective Date 2 February 2015. Thanks.

Let's start with what tables do you have? >> 2 Tables: Customer Agreed Transport Rate , and, Data Entry What fields in each table? Customer Agreed Transport Rate: - Route - Customer - Effective Date - Rate Data Entry: - Trip D/O No - Truck No - Loading Date - Customer - Route - Item -...

Thanks JDraw, Table 2 DATA ENTRY Trip No > Truck No > Loading Date > Customer > Route > Item > QTY 1 > XYZ 123 > 2 July 2014 > A > AAA > Concrete > 100 unit 2 > ABC 123 > 5 July 2014 > B > CCC > Canned food > 200 unit I need advice on QUERY, how to get RATE from above table where DATE is 2...

Due to lack of solution, now I am doing with this way: Route > Customer > "1 June 2014" > "1 Sept 2014" AAA > A > MYR 88 > MYR 77 BBB > C > MYR 99 > MYR 98 Hence, if there is too many different effective date, I could not solve these by IIF.

Hi ALL, Happy New Year! I have tried search through some forums and but still not able to get desire results. Table Customer Agreed Transport Rate Customer > Eff Date > Route > Rate A > 1 June 2014 > AAA > MYR 99 A > 15 Aug 2014 > AAA > MYR 88 A > 1 June 2014 > BBB > MYR 77 A > 1 Sept 2014 >...

Hi Uncle Gizmo, Much appreciate your help! Will try to search DMAX and others in forum. Thank you very much.

Hi Everyone, I'm Calvin, newbie here, just draft our small business database. As topic mentioned, I urged for your help to explain how could let me get auto invoice number.... like press Button or combo box?? Here we got some related info: 10 customers, each I'd like to get invoice number with...