Search results

After some research I have discovered that my issue is likely with using GROUP BY on a memo field (The comment fields I have are memo types). I guess it has something to do with how memos are stored in memory. I have not yet figured out how to deal with this. If anyone has some knowledge in...

Hello, I have received help on developing a query on these forums. However, now I have encountered an issue. I have a parent query that performs a Transform & Pivot on a sub query. The sub query has the data I am looking for in it. However, the parent query has lost the data. First, here...

Wow, you are great. This works perfectly, I can't thank you enough. The mechanics of these queries are quite beyond me right now. I'll be spending some time to desipher and understand them, that is for sure! Cheers mate, if you are ever in the Vancouver, BC area shoot me a message. I owe you a...

I simplified it in my original post in an effort to make things easier to read/understand. Sorry about that. Based on the tables that I attached above, I would like the results of the query to look like this: File ID | Buyer | Description | Assess | Draft | Post | Close | Eval | Award...

Access wouldn't let me save as an MDB so I created one an imported everything. Most of the functionality has been lost due to changes with tempvars, etc. However, the structure is there. I hope this works. Thank you so much for all of your help.

That's good to hear, I was getting frustrated with myself for not being able to understand, haha. Sure, please keep in mind - I am a beginner so I am positive that some of the ways I did things are over complicated or not entirely correct.

Sorry, I was away for the weekend. I must be too new to grasp the concept above, easily. tbl_FileStatus has a record for whether every substage in every file is completed or not. tbl_SubStages has a record for every substage. When a new file is created, the event looks at tbl_Substages to...

Thank you for the response! I will take a look and see if I can accomplish this. There is a problem I have to get around though. I separated tbl_Substages from tbl_FileStatus so that substages could be added in the future through a form. When a new file is created I have written a VBA event to...

Hi, I am an Access newbie and I am looking for help with a problem I have encountered. Please see my attached image for a summary of the tables I am working with. Basically, the complexity of this query is beyond my tiny intellect; and my research into nested queries, inner and outer joins...