Recent content by hishamaboualfa

sort of u r right, but we have load of records per year, do u mean to store all the years in one table?

just to be more specified, please have alook at the attached record, what i want is at quarter basis i can make report showing for each supplier how many shipments and how many invoices per inventory per mode of shipment and the expenses, this records shows two inventories for one shipment, so...

here u go, attached

thanks alot, well, i have Query and a report based on this query, but since i included values from another table for each record, it duplicate the counting, so the question is how i can put expression to allow the query to count the unique value of this field only.

is there is any way to contact you for another support

perfectly worked, specially i added the same in the table to help in the annual reports

Hello Guys please have alook at the attached, I need to summarize all the expenses into two fields, Total ESM & Total Supplier, appreciate ur help.

thanks Boss for the reply, but it didnt solve the issue, I need to facilitate the search for the users to include the data in the subform or compobox

Hello guys, basically i am new here and in access as well, my first inquiry regarding the attached simple form, i guess its self explanatory for what i am trying to do, the question is, usually the users of this form will search for records based on the invoice number and unfortunately the...