RE: update query with summary

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Use a totals query with criteria of zero on the sum, out put the customer
and city.
Use that query INNER join on both fields in your delete query.
--
KARL DEWEY
Build a little - Test a little


"Newbie101" wrote:

I have a lot of data that has debits and credits. Whenever 2 field
(customer/city) matched and the debits and credits sum up to zero, I want to
close out both lines by having "Closed" in a status column.

sample:

customer1 LA 100.00
customer1 LA -100.00

customer2 LA 100
customer2 SF -100

When i run a summary query, customer1 will come up as 0 and i would like to
use an update query to update the data on the "status" field. But since
customer2 is different in city, i don't want that field to be closed.

Is there a update query that will do that? Thank you!
.

Relevant Pages

  • The column prefix MS1 does not match with a table or alias name used in the query. (#107)
    ... One query looks like this, ... SELECT Customer1 overall.*, ... Customer1 Field, Customer1 Staff, and Customer1 Overall are each ... queries with certain where clauses. ...
    (comp.databases.ms-access)
  • Re: Need expert assistance with this (MySQL routine)
    ... Hmm, now after changing that now I get parse error, unexpected '}' in ... > The query is valid, so are you sure the table customer1 exists? ...
    (alt.php)
  • Max date
    ... I have a query that looks that this: ... Customer1 Loan#1 Date Rate ... I need to be able to pull the max date for each loan # for each customer, ... but that's not woring like I need it to ...
    (microsoft.public.access.queries)
  • Re: Query Conflict
    ... the following query with good results. ... I now want to add an additional criteria of the city field. ... The conflict appears to be between the city criteria and the SUM ... the SELECT clause. ...
    (comp.databases.ms-access)
  • RE: To Avoid Blank Space in Combo Box
    ... You can do a delete query where the city is null when the form closes. ... world.now sum of the cities has been entered and sum which not been entered ... well the problem cums many times user leaves blank,so even blank space row ...
    (microsoft.public.access.forms)