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...
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.
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...
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...
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???
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.