Billing and payment debts

[azhar2006]

Hi guys
I like to ask question puzzled me a bit
I have two tables
The first table is for shopping list


Schedule II is paid or provided for purchases in the first table (debt) or (cash)
How do I decrease the amount that has been paid for the invoice for example no. 2 Note that I do not pay each invoice amount and the amount
And how the rest belongs to amounts
I hope to help

[ItsMe]

It is advisable to not decrease the original amount. Instead, you would add (sum) the relative records in table two and calculate the difference between the sum and the original amount (from table one). You can display the result in a form or a report.

[azhar2006]

Thank you very much
Can I keep the results in a table or query
So that I can in the future to return to it.

[azhar2006]

When choosing a password Cash
Yum deducting the invoice value of the materials + amount is automatically
And if they do nothing

[azhar2006]

[June7]

You would 'return' by filtering to retrieve records through a specified date. This is one reason to save raw data and not save calculated data. With raw data and calculating when needed, the situation at any point in time can be recreated by filtering to only the data existing up to that date.

[azhar2006]

Sorry
I did not understand what you mean
Is it possible to explain more
Can I do it or not.
Or is it contrary to the rules

[June7]

Can I keep the results in a table or query
So that I can in the future to return to it.

No, the results are not 'saved', you recreate the results by running query or report that includes only the records that contribute to the calculation. If you want to know what the balance of an account was 2 months ago, then run a query or report that includes only the records that existed two months ago.

[azhar2006]

Thank you
And how to build this query
I know I work in a report
But you have a simple query or axial
Or what

[June7]

Build query as you would any query with query builder and apply appropriate filter criteria. I don't know your database so cannot be specific.

The circle with arrow means you have a post in the thread.

[azhar2006]

Can I use a function (IIf) in the query
And how if (PaymentMade) ("Cash"; "Later"), it?

[June7]

Of course IIf can be used in query but I have no idea what the expression should be for your situation. Don't have enough info. Afraid that's all the guidance I can offer.

[azhar2006]

This is the database please help
With photos illustrate

[orange]

Your data base has a PASSWORD.

[azhar2006]

Please help me