Recent content by AccessWomble

  1. A

    UPDATE query using SQL WHERE, COUNT

    Hi lagbolt thanks for the reply. Within the context of my question so far I agree with you, I see exactly what you mean, and i feel like something has 'clicked', like I've learned something crucial about databases. If i give you a bit more insight into what I'm trying to do however, can you...
  2. A

    UPDATE query using SQL WHERE, COUNT

    Hi everyone Quite new to Access and SQL so this could be something as simple as brackets.. I have tables called: tblSections, and each record in there 'has' x related records in the table tblActions, They are linked via Primary/Foreign keys: SectionsID/SectionsForeignID. I want to...
  3. A

    Advice needed on DB set-up & Normalization for Novice

    Hi Ladies & Gents, I am an experienced in Excel & VBA but new to Access. Want to set up a new DB but need some advice on how to set up my tables and relationships properly. The DB will store details of complex transactions, and (for example) the dates when actions relating to the...
Back
Top Bottom