Updating and Erasing Data

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;

On Jul 7, 8:16*am, taco wrote:
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;

Sounds like you have no idea how to use a query. Why do you want to
overwrite the old data?

Post your table structure - field names and datatype.
Post sample data and what you want the results to look like.
Sometimes it also helps to tell the version of Access and the operating
system.
--
KARL DEWEY
Build a little - Test a little


"taco" wrote:

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;