Updating and erasing data

  • Thread starter Thread starter taco
  • Start date Start date
T

taco

Hi Everyone;

It's hard to explain what I need...
I have a table. Everyday for once new data is getting stored in it. These
latest datas should be transferred and added over values in another table
which comes from earlier dates. Because one customer can have some other
entries in earlier days. After these additions, I need to take daily report
and see which customers deserves ticket. The customers who have more than 1
point can get their ticket. So, after I took the report, records over 1
should be deleted. I've tried make table and update queries but none of them
worked.

Thanks a lot for your ideas and guidence.

Best Regards;
 
Hi Alex;

Thanks for feedback. I already have data for last two months. I've created a
new table with a "make table query". In this new table I have sum amounts of
last two months. I have customers who visited 2 times and some customers
visited 20 times. Starting from today, new datas should be added over these
sum datas from the original table they have been entered. That append query
is not working. It's creating 16.000 thousands of new records. I've started
to think maybe I should try to write a VBA code for all these transactions.
Looks like this is over my knowledge and ability.

Thanks a lot.
 
Back
Top