Search results

  1. W

    Solved Query to Return Most Recent Date

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

    WildCards wtih Null values

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

    Issues with a Query

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

    Solved Linking Table With Multiple Rows

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

    Printout steps within a macro?

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

    Finding Records with increased values

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

    Data Entry Form

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

    Opening Another Access DB

    I have a current database that will open up other databases and run macros. The current database has a form which lists out the path of the other databases and the macros that need to be run. Currently all of this works fine. However, we are finally moving over to Windows 7 & I am running into...
  9. W

    Compare Data on Tables for Change in Value

    I am not sure if my question should be posted here or under queries but I thought I'd give this a shot. I'm new to the forum and by new means an expert with Access but I can follow directions and usually tweak other folks' stuff to get it to work for me. Anyway, I have two tables (Current and...
Top Bottom