Recent content by milodm

Okay, it may take me a half day or so to remove the sensitive data and then back fill with data to make it relevant. Thanks in advance for the help

Yes Pat, PK is MASTER.COMBO

Thank you very much for responding and helping me out with this issue! You will have to excuse me for my stupidity, I am a self taught Access user and I have had one very general SQL class so I am limited in expertise! To answer the first question, yes the TOP20 query is updateable and the only...

So if I am reading that link correctly, I should look at doing this via a subquery verses a join like I have this query setup now? The problem with that is my SQL knowledge is at best marginal, since reading the post I have been trying to get it to work and I still have no results and I am...

Hello smart people who know a lot more about this stuff than I do!! I need some help on a project I am trying to accomplish. I am building an Access 2007 database that will allow multiple users the ability to track and update Open Orders that need to be billed or have not been billed for some...

Brian, Here I thought this was going to be some elaborate query and come to find out it was as simple as using the Query Wizard and the Unmatched Query like you suggested! I did the unmatched query and it worked...success!! Thank you so much for all your help and being patient with me!! Thanks!

Brian, I went back and renamed my queries to remove spaces as you suggested and still no luck. Below is my SQL SELECT TOP 100 MASTER.COMBO, MASTER.[Customer Name], MASTER.Status, MASTER.CCD, MASTER.Area, MASTER.[Order Type], MASTER.[Order Value], MASTER.AGE, MASTER.ANALYST, MASTER.COMMENTS...

Brian, I am probably showing my stupidity here so please bare with me. Okay, I am doing this in Access 2007 and I have the one MASTER table (Primary Key is "COMBO" field) and off that table I want to have 2 separate queries, one that returns the TOP20 records (ORDERS) based on ORDER VALUE and...

Brian - Damn..I knew I forgot something. PK is "COMBO"

I am probably a intermediate Access user, what I know is self taught or from a book and or Google research. The vast majority of what I do is working directly in Access via Query Design; I do a little in Access via SQL but not a lot, I do know how to interpret simple to intermediate SQL but...