Hi guys,
I have another question I need some help on, how can I transfer a field from one table (or query) to another? So I have a sales table with a field "counter" which keeps count of the sales for each customer (cust A 1,2,3,4, custB 1,2,3,4 and so on). Now I think storing it this way is inconvenient big time, and I thinking of storing just one value in my customer Table, but first I need to move the maximum value of this field into my customer table to keep continuity. How would you do it?
Niroth
I have another question I need some help on, how can I transfer a field from one table (or query) to another? So I have a sales table with a field "counter" which keeps count of the sales for each customer (cust A 1,2,3,4, custB 1,2,3,4 and so on). Now I think storing it this way is inconvenient big time, and I thinking of storing just one value in my customer Table, but first I need to move the maximum value of this field into my customer table to keep continuity. How would you do it?
Niroth