Recent content by woodsy74

That looks like a winner. Thank you very much! Appreciate it.

Hello All, I seem to be stuck on this query. A Customer can have multiple AccountTypes which can have multiple entries by Date. I am trying to query the most recent Date for each AccountType per Customer. So, looking at the below sample I would want to return rows 3,4,&5 (row 1 is the field...

So that sort of works. The issue I see is that if the user selects a Product Category on the form they are now returned the records which have that selection plus all of the ones which are null. If the user selected a value for Product Category then I only want to return those and not the nulls...

So that sort of works. The issue I see is that if the user selects a Product Category on the form they are now returned the records which have that selection plus all of the ones which are null. If the user selected a value for Product Category then I only want to return those and not the...

There’s a form in our db which allows users to run a query for all the records based upon a few fields they’ve input on the form. Below is the query that gets run from the form. It was working fine until I added the last line because they wanted to be able to filter by Product Category. It still...

I added the second Order By and it seemed to work for me. I just need to discuss with users to make sure what I am using for the second Order By makes sense. As far as the storing of the data I have no control over that. This is how the db is set up already. I was just trying to extract what...

This seemed to work in my sample the db for Part I. Another question though. Is there a way to account for times when the same Account_No is using the same Date? I tried running this against a larger population of Customer data and I got a message stating "At most one record can returned by...

Sorry, I meant to write <=. When I do that I get all of the balances for the Account Number that is <= the DateEntered and not just the one balance per Account Number that is closest to the DateEntered.

I am struggling to get this query to work. I can get the answers I need if I dump everything into excel but I am trying to get it done via Access so other users can get what they need with one click. I've attached a Test db with samples of the two tables being used. tbl_CustData contains all...

EBS17, what you have listed seems to be working for me. I will try incorporating it with the real data to make sure it works. Thanks for all your help!

Attached is a Test Version of what I am doing. This doesn't match the examples I posted originally but the concept is the same. In Query1 I am just trying to pull in Orders #1 and #7. Order #1 returns because it's a PRODUCT_ID that is priced daily. Order #7 is not returned because the...

I am trying to query using two tables: ORDERS and COSTS. Based on the PRODUCT_ID and ORDER_DATE in ORDERS I want to find the correct PRICE from COSTS using the PRODUCT_ID and PRICE_DATE. I had joined the two tables by PRODUCT_ID and wrote a criteria on PRICE_DATE of >=[ORDER_DATE] and...

Thanks all. The Database Documenter seems to get me what I needed.

I've inherited a few Access macros and I am wondering if it's possible to printout all of the steps that contained within the macro. I'm trying to walk through them but they each have 30+ actions so it would just be easier if I could printout each action and then walk through them. Is that...

Thanks all. The subquery technique seemed to get me what I needed. I appreciate all of your help.