Search results

Thanks for the input, but Im not sure I understand. I have changed table names in my test scenario (and tomorrow in all the tables in the production database) but both my queries are duplicating values in TableA which moves from 29 records to 43 in both query results. Im not attempting to do...

Sorry, when I replied to plog I had not seen your questions. Thanks for getting back to me. Attached is an updated file with my problem. Any suggestions would be appreciated. Thanks! Peter

Ok. Per your request, I've thinned down the data with TableA, TableB, TableCDesiredResults and added my Access query and what results that query produces. I hope this is what you wanted from me and find it useful. As you can see, my query turns 29 records into 43. Doesn't seem like much, but...

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...

This works fantastically! I understand the logic clearly. I've incorporated it into the database we use and it works brilliantly. I can think of other applications for this as well that will help me with future projects. Thanks very much! Peter

TransNumber SoldDate ProductName Price 34 06/11/17 45 06/11/17 54 06/10/17 54 06/10/17 34 06/09/17 45 06/08/17 23 06/08/17 23 06/07/17 34 06/04/17 45 06/01/17 Result: 23 06/07/17...

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...

Thanks! Of all the conflicting and confusing info I've forced on myself through searches, I think you've given me the direction I needed to more specifically figure this out. I appreciate your assistance very much. Will hope to get time to tackle this tmrw at work. Thanks again!

THanks for getting back to me, but no, I'm stuck. I cannot seem to create a data entry form that allows for what I'm trying to do. I've tried using the form wizard to no avail. I'm attempting to create new records in tblErrorLog, using drop down menus for one field each from the tblEmployee...

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...

Cool. I will check this out. Here's where I am now: I created a make table query from my Qry1 and 4 append queries (my queries 2-5) which creates a table with two fields: Rx # Blank1 Where Blank 1 is the designated term denoting which query contributed to the Rx being added to the...

Appreciate the help and speedy responses. Trying to keep this as simple as possible, and I don't mind running several queries to get this done. Most important, is to get this information on paper as soon as possible using a process which is repeatable and accurate. Each of my 5 queries...

The tables are direct extracts from an off the shelf pharmacy dispensing application my company uses. The data in the tables represent different moments in the lifespan of a prescription and values for similar fields vary between the two, but are still important in their own respect. Combining...

Thanks for your willingness to help. I attempted to make this report consolidation effort as simple as possible because we're purchasing an add on product that will make this effort obsolete in 90 days. Essentially, I'm thinking I can modify the queries to return just the Rx# for each query...

My limited knowledge of Access / SQL All Queries performed in Access, Below are SQL views Query 1: SELECT ClaimData.[Rx #], ClaimData.[Is COB], ClaimData.[Generic Indicator], ClaimData.Code, ClaimData.Adjudicated, ClaimData.Sold, ClaimData.[Dispensed Name], ClaimData.[Dispensed NDC (with...

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...