Search results

  1. P

    Two tables, many to many relationship, append fields

    Hi everyone, I hate to be a bother but I'm in need of assistance. I have two Access tables (extracts from off the shelf software that I've imported into my database). The tables share a common field (Rx_#) in a many to many relationship. The first table, (I'll call Table A) is currently...
  2. P

    Finding second unique MAX value

    Hi everyone. I'm new to Access and don't use it frequently. I've taught myself how to use MAX and MIN values in a query with some success, but I have a user request that's a bit more tricky. For the simplified version of a table below, I need to create a query that will return the SECOND most...
  3. P

    Newbie question...data entry form, multi-table

    Hi to everyone. I've attached a Word Doc with a question I have. Not a developer by any means (I manage a pharmacy) and have zero tech support. I am trying to create a data entry form that connects to 4 linked tables that allows a user to quickly and painlessly record a function of their job...
  4. P

    Multiple query combination - unique values

    Hi all. I'm a newbie to access and have a question I hope someone might be able to shed light on and point me in the right direction. Have 5 separate queries that pull transaction data based on different variables. I need to combine the results of all 5 queries into one dataset, from which...
Back
Top Bottom