|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
February 8th, 2005, 03:41 AM
|
|||
|
|||
use query results in vb code
I'm very frustrated. I have two tables, tblPoints and tblProducts.
tblPoints contains PointID (PK), CustomerID, ProductID, Date, and Invoice Number. tblProducts contains ProductID, ProductName, and PointValue. At the click of a button, I want to check to see how many points a Customer has for each of the three products. If the Customer has = 11 points for any of the three products, I need to move the 11 purchases that the customer made from the tblPoints and put them in an archive table. I can check each product separately if needed. I've tried numerous approaches and I can't come up with a solution. Any assistance at all will be GREATLY appreciated. THANKS! -- Message posted via http://www.accessmonster.com 
|
|
#2
February 8th, 2005, 03:57 AM
|
|||
|
|||
|
Let it also be noted that I have the total amount of products purchased for
each product showing on a subform for each customer. -- Message posted via http://www.accessmonster.com
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| dynamic crosstab A2002 | Brigitte P | Running & Setting Up Queries | 13 | January 2nd, 2005 04:25 PM |
| How sql server returns query results in vba code? | Sunny | New Users | 0 | December 20th, 2004 03:14 PM |
| Attn Sprinks- Not duplicate insert records | babs | Using Forms | 1 | December 13th, 2004 06:25 PM |
| Too Few Parameters error Mail Merge Access Parameter Query | Tony_VBACoder | Mailmerge | 3 | September 14th, 2004 12:15 PM |
| Query not providing correct results. | Lisa Beach | Running & Setting Up Queries | 0 | August 9th, 2004 08:17 PM |
Linear Mode
