Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2002
    Posts
    1

    Unanswered: Tracking Subscription Credits

    Howdy,
    I'm a fairly inexperienced Access user who is learning by randomly clicking things and trying them out.

    So far I've gotten fairly comfy with flat databases...still haven't gotten the hang of the whole relationship thing...and I'm not sure how to do it in a database either.

    Anyhow, my current problem is as follows:

    I'm setting up a database to track customers and subscriptions for a small-time magazine I publish. The key part that's got me stuck is tracking "subscription credits".

    Every account would have a sum of credits. (Credits are obtained by either purchasing them, or contributing content) Now, everytime I publish an issue I want to be able to click a button that "magically" knocks one credit off all accounts.

    So far I've tried building a query that subtracts the current issue number. However, that got very messy as it asked for that number everytime I looked at any account files.

    Any ideas?

    Thanks!

    -Ryan Pilling

  2. #2
    Join Date
    Nov 2001
    Posts
    336
    you possibly need to use an Update type query like this:

    UPDATE Orders SET Credits = Credits - 1, DateUpdated = Now() WHERE Credits > 0;

    HTH,

Posting Permissions

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