Recent content by Poptartme

Actually, I want the QTY column go into override column. That's all I want. Basically, I have Excel data in the format shown below. And I want this Excel data to replace overide column in ACCESS table. How do I set this up in ACCESS so I can write a query/macro in ACCESS that does the...

based on Item no. If the item numbers in two tables match, then update Table 2. thanks!!

I want to update Override field in Table 2 using Qty column in Table 1. How do I write this query? Thank you!!! :confused: Please see attached tables.

I have a report based off of table. I have a query based of off same table that does count on one of the columns. I want to display this count on the report. I added a text box on the top of the report and try to link it to the query but I get an #ERROR. Can someone help me what I am doing...

Table 1 Item No A B C D E Table 2 Item No Sales A $10 B $20 C $30 I want to be able to select all items from Table 1 and matching records from Table 2. I want the result to look like this: Item No Sales A $10 B $20 C $30 D...

Audit Trail table changes I want to be able to audit trail any changes in SQL server table. How do I go about doing this? I would like to be able to run a query on a daily/weekly basis to find out what was added/modified/deleted from the this table. Thank you, Poptartme. P.s the reason I...