I could make a customer table with little effort.
The two customer fields are customer number and customer name. Customer number is unique to that customer. Each transaction has an order number and invoice number that could be concatenated to be a unique field. What I am looking for, though, is that customer's total purchases for a sku over 1 month's time that would then be summed to a total sell for that sku. From about 1 million...
dcrandall
Last Activity: Jun 21 '07, 08:37 PM
Joined: Jun 21 '07
Location:
-
1) There is not a specfific customer table as customer are added very often.
2) There are two fields for customer, 1 that is numberic, the other is the text name.
3) Ext sell is a dollar value
4) The size of the order is determined by the quantity sold multiplied by the selling price per unit to achieve an ext sell....Leave a comment:
-
Thanks for the reply. Could you give me some more detail as to how I would accomplish this? The dataset that I have has a customer, part, and ext sell. The dataset has many customers and the dataset will be renewed every month with different customers. I am trying to retrive the 25 largest sales per customer.Leave a comment:
-
How to a Numerical Sequence to Query
I have a query that lists customers purchases. I only want to return the first 25 records for each customer. My thought was to add a numberical sequence where each purchase from the customer was sequentially labeled from 1 to XX. When a record for a different customer arrives, the number sequence would start over at 1 again.
Can anybody help me with this? This is beginners question. Thank you for any help that you can provide.
No activity results to display
Leave a comment: