Search results

  1. P

    Entry duplicated itself

    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
  2. P

    How to begin DB design

    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...
  3. P

    Turn Null into 0

    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...
  4. P

    How to get $0 when no payments

    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...
Back
Top Bottom