Search results

Sorry, here's the database

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

Not sure the database up loaded, sending again. Thanks!

Here's the database, has the report and query in it. The name of the sub report is Labour PCS sub report. And then the main report is Costing CS Report. Thanks!

Yes. So you think it's something other than my expression? I do know that for this sub report there is no data. But there is data for the other sub reports. And then at the end I have a total and it's not printing, so I have to be able to allow for nulls or zeros.

Yes. What I have in my sub report now is the expression above. Thanks!

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

Great! I got it! Thanks for your help!!! I'll mark this completed.

I'm having troubles with my waste factor field, it's type is percent. In my table comes out as Ẹ. Can't find out anywhere what that means??? Any help on this? Thanks!

Ok, think I got it! But when you do the Forms![MyForm].[FieldName], how do you express numerics? One field is a numeric(double number) and the other a percent. Thanks!

Ok, don't think I'm explaining myself or I'm just not making sense. This form has the 4 fields in it for the end user to request what data they want ran for a report. It use to create a table from these 4 fields, which then in turns runs a macro that runs many queries to calculate an ending...

Thank you for your suggestions, appreciate! I do understand the skepticism in your replies, but this is a database that was created by someone else and I'm just trying to do something for the end user while the main programmer is gone. I don't want to start fixing everything, just want to get...

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