Search results

  1. C

    Problem, why is my query giving me data that it shouldn't

    Hi, Having a problem within my database. I have a form "Costing Sheet RL Form" Within this form I enter the data I want for a report. The first button "Run Macro" runs a macro that runs a qry " Delete record from Costing Sht Hdr tbl qry" which deletes the record from the last request. Then...
  2. C

    getting #error on my report

    I'm getting #error on my report. This reports has 8 sub reports. And of course the sub reports are from different tables. How do I handle results that are 0? For example: Here's my calculation IIf(Sum([cost/lf]) > 0, Sum([cost/lf]),0) and this was done in expression builder. What am I...
  3. C

    How to make a new table from fields entered in form

    Hi, I want to know how to create a new table from 4 fields entered in a form. The reason I'm doing this, because I'm creating a report that goes through numerous macros to come up with the results. And in the beginning I'm creating a table that is use in all my queries. But not knowing how...
Back
Top Bottom