Recent content by Sandrra

  1. S

    queries with multiple tables

    hi Samo, Answer to your questions: 1. price changes can happen everyday or at once a week. 2. no, can change on a per product and it can only be one component of prices (product cost, or freight cost or discount) 3. maximum of 20 products And yes, its true dates are overlapping. Can this...
  2. S

    report results

    Thanks for this, was able to use it...:)
  3. S

    queries with multiple tables

    I'm not sure if this link will work. This link contains zip file of my sample dbase... https://www.dropbox.com/home#!/home/Dbase thanks and hope to hear comments and suggestions...:)
  4. S

    queries with multiple tables

    I am trying to attach sample data but the system doesn't allow me to upload it. Sorry
  5. S

    queries with multiple tables

    I want to limit my result to a recent date, either prior or equal to given date?
  6. S

    queries with multiple tables

    can someone explain how the expression "LAST" works. Does this mean it will only get the last record, or last record of each customer and product? I tried to use it, some are correct but some are not. instead of last record, it gives me the first record of my product?
  7. S

    queries with multiple tables

    Is it advisable to eliminate or delete field Date to from all tables?
  8. S

    queries with multiple tables

    Hi Samo, I am suppose to upload sample file but failed. Can I edit your Access DB for me to show what I wanted to get? Thanks! :)
  9. S

    queries with multiple tables

    Hi Dylan_dog, Thanks for this and so sorry was not able to immediately reply as I was out for 4 days without internet connection. I also got the same result as yours. Is it possible to limit result to a list of products of each customer (no duplicate product) pulling last price of each table...
  10. S

    queries with multiple tables

    Hi! Here's my sample database and the output I wanted to produce. I hope you can figure it out how this will be done. :o:o Thanks, thanks so much. Cheers!
  11. S

    queries with multiple tables

    Thanks for your time, I really appreciate :) let's say table 1 is the product cost, table 2 is the specific pricing per customer and table 3 is the transport cost. product cost change frequently - it can be daily, while the 2 tables changes seldom. Now, I want get the pricing components with...
  12. S

    queries with multiple tables

    I am trying to build this in one table but the problem is the effectivity (date from and to) of each pricing components are different. :(
  13. S

    queries with multiple tables

    hi! I need help, please. I have multiple tables, say 3 tables table 1 table 2 table3 date from date from date from date to date to date to place place place...
  14. S

    New Member Greetings

    Hi! I'm Sandrra and I am from Philippines. I'm new in MS Access. Though I am having a hard time to understand and make commands/queries, I felt challenge and I don't want to give up. I want to learn as well as I want to share what I learnt...:)
Top Bottom