Search results

you can upload it here

We are here to solve your problems and giving you advice no one can charge you for giving advice on this forum

can you upload database zipped (if possible)

At which routine it gives the error I think its Update Sequences

Is your problem still not solved

You can make the vendor code and invoice number primary key

No need to creat a delete query for a make table query because data will be deleted automatically each time make table query is run However you may need it for and append query

What do you want to count

I think you can do it yourself now

cant understand

Download the attached file

Download the attached file and check if it fulfills your requirement

use this as control source of field =dlookup("[SumOfPrice]","[stationary jan]")

Can you explain in detail what value you are trying to retrieve

Customer 5 also belongs to asset3 and asset4 why asset4 is not in category 1 i mean first record

i CANT UNDERSTAND THE CALCULATION BECAUSE I HAVE NOT SEEN THE ORIGINAL DATA Tell me the customer balances and asset values

It cannot be displayed like this field must be in record source of form or in query or table which set as recordsource

Set the control source of the field on form to the field on query

Download attached file and check queryFinal should it be like this

Still not able to understand what are the results you want