Recent content by jamil_786

Dear Friends, I need some help. I have a Database with 4 forms with different fields but one field is common in all forms "Civil ID/Passport". I want to go the specific record of the another form with the current open record of the form with the help of command button.

Thanks Ken. I tried DSum and DCount but there is msg showing with error. I wrote this =DSum([AGE (DAYS)]>30,[$ AMOUNT])) =DCount([AGE (DAYS)]>30,[$ AMOUNT]))

Dear Freind, I have a report with following format (Age)($Amount) 90 100.00 90 200.00 60 100.00 30 200.00 14 500.00 10 700.00 I want to see the following result in report footer in that way Amount Count 60 to 90 400 3 30 to 59 200 1 <15 1200 1

Sorry there was typing mistake. The correct is Invoice# ABC 123. There is wrong Invoice# mentioned in PO Aging.

Dear freinds I have two queries “PO Aging” & “SC Aging” based on different tables and the queries show with below results. PO Aging Vendor PO# Invoice Age days ABC 23 456 12 DEF 899 222 10 SC Aging Vendor SC# Inv# Age days AFG 963 222 5 XYZ 852 111...

Thanks DCrake for your reply. Freind i did as you mentioned in your reply the form is opening in popup but it is same in maxmize window as the main form window. I want the form will open in a small window than my main form window.

Dear freinds, I have a main form in my Database and i made another form that is opened with a command button from main form. I have a question that i want to open the form that is opened with command button from main form in small window so that i'll be able to see the information of main form...

HI, I made Subform and my main form and i did formate in subform but i could not see any formatting in the Subform. There is any solution for this problem.

Hi Freinds, I am new in this forum and this is my first question. I made one query from my table with feilds "Purchase Order#" & "Invoice Amount" and i used totals with order by of "Purchase Order#" and Sum for "Invoice Amount". So this query is giving me the right result. But the problem is...