Search results

I have a table order n a table payment. I need to go to the last record in payment table n perform a check on datepaid. I achieved this by using query with last(paymentid). I want to know tht if datepaid of last paymentid is null. Query should fetch the data of previous paymentid for a specific...

On main form i m using two subforms. On both subforms i m using fields to get sum of amount using sum function n then using these sum amounts on main form for few more calculations. As i update amount fields on subforms, the fields that show the sum of amount goes blank n bcoz of this other...

I have a report tht accepts date as input parameter. Default view of report is set to print view. I m using a switchboard to open the report but it always opens the report in report view and when i change report to print view at runtime, it asks for the input parameter again. I change the switch...

I want to creat a report of lease contract. In which some of the information is static that will remain same in all conract reports but there is some information that changes depending on tenant or you need to remove some clauses of contract in some special cases. Is there anyway that user can...

I m using access 2007. I want to use following update query in access vba but its giving error. Query is: Docmd.RunSQL ("UPDATE property set property.status="& "'empty'" & " Where property.propertyid="& me.cmbpropertyid.value &"") It gives the following error: Missing ),], or item in query...

I have a table name property with fields propertyid, houseno, address, housestatus(empty or rent) and another table lease with fields leaseid, propertyid, startdate, enddate, monthlyrent. I need a yearly report showing the number of months in which house remained empty. Is it possible to...