Results 1 to 2 of 2
  1. #1
    Perfac's Avatar
    Perfac is offline Expert
    Windows 7 64bit Access 2016
    Join Date
    May 2016
    Location
    Centurion Pretoria
    Posts
    618

    Max or Dmax?

    In South Africa our VatRate increases from 14% to 15% on the 1st April. In my Vat table there are 9 Vat Codes or Catagories. 4 which will have rates and 5 that will have a zero rate since it is Zero rated items and Exempted items. It is the first time since VAT came in 24 years ago that there is a change. Developers are scrambling right now. I want to learn how my application can do what I want it to. I want:

    a. Invoices up to now is connected to those records, I cant see changing those records.
    b. 4 records is going to be added to the 9 there. The Vatcode is going to be the same for the 4 that change.
    c. But the rate will change from 14% to 15% and there is a "StartDate11" field.


    d. For my customers using my app I want them to simply enter another record in Table t02VatRate and things must be right if there is a change in future again.
    e. It would have been a solution if I could find the way to filter a query to show 9 records with the newest in Startdate11 against Vatcode. Pbaly has given me a way to result in a query with the needed records, but the query is not updatable, and I can not use that for the invoices. A few of you guys has tried to help me, but no luck yet. I am trying again.

  2. #2
    CJ_London is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    c. But the rate will change from 14% to 15% and there is a "StartDate11" field.
    you do need an 'effective from' date of change field so you know which rate is relevant for any given day.
    d. For my customers using my app I want them to simply enter another record in Table t02VatRate and things must be right if there is a change in future again.
    they will need to add the relevant data as and when it changes in the future unless you are providing some sort of update patch to add the new records - and if so, if you are providing a good service, a method of confirming they have applied it.
    e. It would have been a solution if I could find the way to filter a query to show 9 records with the newest in Startdate11 against Vatcode. Pbaly has given me a way to result in a query with the needed records, but the query is not updatable, and I can not use that for the invoices. A few of you guys has tried to help me, but no luck yet. I am trying again.
    don't know how your app is working, but I would not expect you to need an updateable app for invoices - the invoice will either store the rate looked up, or you would store the PK to the relevant record

Please reply to this thread with any new information or opinions.

Similar Threads

  1. DMAx Question for Report - DMax <= Dtae
    By crimedog in forum Access
    Replies: 8
    Last Post: 12-29-2014, 09:31 PM
  2. dmax value
    By sdel_nevo in forum Programming
    Replies: 2
    Last Post: 09-12-2013, 04:14 AM
  3. DMAX in VBA
    By Meanfish in forum Access
    Replies: 1
    Last Post: 11-03-2012, 11:06 AM
  4. Replies: 6
    Last Post: 07-24-2012, 03:02 PM
  5. How to use DMAX
    By tomneedshelp in forum Access
    Replies: 2
    Last Post: 03-01-2012, 07:22 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
  •  
Other Forums: Microsoft Office Forums