Search results

Form and subform are linked at the Project ID field. I think thats the right way because payment has to be linked to a project. But the duplicated payment was not associated to any project. as I said earlier that the Project ID field was empty for duplicated record. If my Master/Child linking is...

No I entered it once only. It shows only once on the form where I can enter. its the table and subform where it shows twice. how I can tell that it has duplicated itself is that the one I enter legitimately is associated to a project ID, but this duplicated one shows no project ID (Project ID...

This is the first time I have seen it happened.

Hi all: When I entered an amount of $365 in a subform. It shows twice in table and even when I go back to subform itself. However the original entry is only entered once. Can anyone tell why this must have happened. It messes up my reports and balances and all.please help! Thanks

Hi all. I have departmental survey results in an excel file. Survey has three main parts i.e. Logical , Physical,Network, and application security. These categories each have like 10-15 queations. Depts. have answered Yes no or unsure to these questions. Since there are 20 diff. depts. who will...

It worked...Thanks a million!

Thanks Peter.. I tried Nz. for some reason when I entered criteria, it only shows the one that have value. The one with Null value are completely eliminated from the query result

Please help with how can I make records that have Null value to return $0 in a query. Right now it is leaving null records empty and shows value for the ones that have values. Payment ID Payment Amt Payment Date Payment Descrpti 416 $927.00 10/2002 Headphones 417...

Hi all.. My report is based on a query and some fields of this query are based on other queries (like sum of all payments etc.). my problem is that when there is no payment, I want to see $0 under payment and Balance (calculated field) according to the payment. Everything is fine when there...