Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. AccessUser207

    Top 2 Items for 2 unqiue fields

    YES!!! Thank you both. Thank you GingerR for all the work. My project works perfectly paul
  2. AccessUser207

    Top 2 Items for 2 unqiue fields

    I ran the code and it works beautifully. I just was simplifying it more than I should it really has three columns. field 1 field 2 field 3 a 8 apples b 7 bannanas b 6 mangos a 2 berries b 4...
  3. AccessUser207

    Top 2 Items for 2 unqiue fields

    GingerR The code works, however, I need to pull various text in field 3 into the new table and I tried inserting the following line and it gave me an eror. rsFinal!Field3 = rs!Field3 What other lines do I need to add.
  4. AccessUser207

    Top 2 Items for 2 unqiue fields

    I want to take the top 2 items in a list. I want to get the top 2 for both field 1 = a and filed 1 = b. For example say my two field look like this field 1 field 2 a 8 b 7 b 6 a 2 b 4 My result would look like a 8 a...
  5. AccessUser207

    Charts not Updating when I scroll through Report

    I need to have a macro called on the "on print" option in properties but I do not know how to build a macro. I am familiar with Excel VB, but the macro design view is confusing, it looks like I can only select drop downs from the action column heading. How do you build a simple macro for a first...
  6. AccessUser207

    Charts not Updating when I scroll through Report

    I have a Report that has a Chart at the bottom of each page. When I scroll through my report, several pages long, I see that the report sometime does not update. Is there a way to force my chart to refresh???
  7. AccessUser207

    Results in Select Query Not Protected

    I need help! I am new to microsoft access and am running a select query and after I run my query on this machine (the other machine works fine) I am able to modify data in my datasheet view (something I want protected when I run queries). How do I change this. What is wrong??? Thanks for your...

Part and Inventory Search

Back
Top