Search results

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.

My table has Product, Date, and Value on it. Each month the table gets updated with all current Products and their Value so one Product may be listed on the table 50 times. Most times the Value will be the same or slightly lower. I am trying to query the table to catch times when the Value...

Thanks Ridders that seems to do the trick. I just have to hope that everyone will be OK with having to re-enter all of the data when they need to make multiple requests. I am using the excel step for a few reasons. Mainly because it was already built out and contains multiple sheets of lookup...

I currently have a Form where the user inputs about 15 fields and hits a submit button. When they hit the button the 15 input fields populate an excel file which calculates and then returns about 5 output fields to the form to show the user the answer to their submission. All of this data is...

I've tried using Set appAcc = CreateObject("Access.Application") but I get the same ODBC Connection error when it tries to run the macro. I think when the code opens the new MS Access it is going to C:\Program Files (x86)\Microsoft Office\Office15\MSACCESS.EXE. In order for the ODBC...

The queries don't run because I get ODBC Connection errors. The queries only work when we open databases through a desktop shortcut that was set up by IT. That's why I am trying to control how the new Access is created. I don't think I am allowed to set up a Windows Scheduler. We had asked...