Recent content by DrAtsab

it seemed not to work without spaces before the "&'s" but having just checked it you're right - there are no spaces.

Thanks for that khawar - works a treat......as long as you put spaces in the right place

Been pulling my hair out on this one. I have a continuous form based on the results of a query. Among the fields are "debit" & "credit" there is another field called "balance" which is not bound to the query. I need the field "balance" to be populated with a running sum like you can do with...

Thanks Thanks for that - i thought it would be simple but just couldn't find the syntax anywhere:)

I have a form in which I have a sub form containing multiple rows. All the rows contain the same text boxes and combo boxes – all named the same but with the row number on the end of the name: txtFName1 txtSName1 txtAmt1 txtDiscount1 txtTotal1 txtFName2 txtSName2 txtAmt2 txtDiscount2 txtTotal2...

Thanks all for your help.

Not Quite. I have a table of transactions some of which are invoices unpaid. On my form i choose a supplier and in the subform list all the invoices that are unpaid for that supplier. The fields i show are: Invoice_Amount, Invoice_Date, Transaction_ID. I also have two other fields that are...

Hi All My first posting - probably of many if this week is anything to go by. I have a child set of records that show outstanding invoices per customer showing as a subform/datasheet. I have two blank columns, one I am populating with the amount I wish to pay and the other which automatically...