Results 1 to 2 of 2
  1. 07-30-2013, 07:56 AM #1
    Alex Motilal
    Alex Motilal is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Nov 2008
    Location
    Coimbatore, India
    Posts
    193

    Tax Table


    Re discussion in https://www.accessforums.net/access/...orm-36205.html
    Dear June7,
    Since Tax rates changes often, I feel it will be appropriate to create a separate Tax table with three fields: DateFrom, DateTo and ApplicableTaxRate.
    Then create a DLookup function to calculate the Tax in the report.
    Do you feel my suggestion ok?
    Alex
    Last edited by June7; 07-30-2013 at 01:28 PM. Reason: split thread
    Reply With Quote Reply With Quote
  2. 07-30-2013, 12:08 PM #2
    June7's Avatar
    June7
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,644
    That is reasonable. Would have to use on form and reports.

    Could save to the order record the ID of tax record returned by the DLookup.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. Need 2 fields from table 1, using lookup info from table 2, put into table 3
    By aarong83 in forum Access
    Replies: 3
    Last Post: 06-28-2013, 01:59 PM
  2. Matching People (Table 1) with Organizations (Table 2) Based Upon Interest (Table 3)
    By kelann in forum Forms
    Replies: 4
    Last Post: 08-30-2012, 07:58 PM
  3. Using 'aliases' table as a lookup table to find the primary key 4 'main name' table
    By Tara1981 in forum Database Design
    Replies: 8
    Last Post: 03-22-2012, 08:48 AM
  4. Link same table to two table.Dataentry in main form & sub-subform from same table
    By ozaman in forum Forms
    Replies: 2
    Last Post: 08-01-2011, 11:35 PM
  5. How to make query based on external access DB's table and the table in linked table?
    By aquaraider in forum Queries
    Replies: 2
    Last Post: 10-27-2009, 07:09 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Other Forums: Microsoft Office Forums