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
|
|||
|
|||
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; |
#2
|
|||
|
|||
Updating and Erasing Data
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? |
#3
|
|||
|
|||
Updating and Erasing 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; |
Thread Tools | |
Display Modes | |
|
|