Results 1 to 5 of 5
  1. #1
    Join Date
    Mar 2004
    Posts
    3

    Unanswered: Conditional Value help

    I work for a real estate company with 520 apartments. I have an access db that I want to be able to update all prices by unit type without manually entering all 520 changes. I currently have a small table that has all unit types with current prices. Is it possible to update the smaller price table while sumultaneously updating all other tables? Is it also possible when entering new unit types to have a price autopopulate in the correct column based on the external price table?

  2. #2
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    Yes to all ...

  3. #3
    Join Date
    Mar 2004
    Posts
    3
    Ok, now that I know it is possible, how would I go about doing it or where could I find the info to do it?

  4. #4
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    Originally posted by gapletona
    Ok, now that I know it is possible, how would I go about doing it or where could I find the info to do it?
    Pick your poison: Wanna do it thru code? Wanna set it up thru macros, queries, and such?

    The possibilities are endless ...

  5. #5
    Join Date
    Mar 2004
    Posts
    3
    I'm new to scripting and I've never written macros so which ever you feel would be the easiest, just point me in the right direction.

Posting Permissions

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