Recent content by AlexPYTH

  1. A

    Table design involving time data (quarterly and yearly)

    Thanks plog. I will try that.
  2. A

    Table design involving time data (quarterly and yearly)

    Thank you guys for the words of wisdom. I still feel like a barefoot toddler trying to navigate a floor full of mousetraps. This is scary stuff for a novice user and I have found fear to be the greatest inhibitor. The solution is perseverance. I have taken the Query approach on this and things...
  3. A

    Table design involving time data (quarterly and yearly)

    Thank you both for the great suggestions. Doc Man, I will take your recommendation on board as a vetting tool to ensure I have no duplicates on a separate query. Thanks for pointing out Dcount. Plog, I have implemented your suggestion and it looks like it's working. I now have 2 fields in my...
  4. A

    Table design involving time data (quarterly and yearly)

    Thanks to both for the info. I have done just that. I now have 2 tables, one with the list of Brokers (tlbBrokers) and one with the Sales and Purchases numbers (tlbContributions). I have them linked with a BrokerID which acts as a foreign key in the tlbContributions. The problem I run into now...
  5. A

    Table design involving time data (quarterly and yearly)

    Hi everyone, I have been working/struggling with the following project for some time and I have just decided to ask for help. Please let me explain the background as best as I can. I want to capture Quarterly Sales and Purchases data (amounts and number of trades) according to a list of...
  6. A

    Hello Forum people

    Hello all, I am a novice user of Access, but very eager to learn as much as possible. I have delayed my IT training far too long and now I am suffering the consequences. Looking forward to a good educational experience that everyone involved hopefully will benefit from. Kind Regards, AlexPYTH
See more
Top Bottom