Search results

Sorry about the delay. "part# footer" is in main report. But it is not in report footer but "part#" has its own footer!

Thank you on your replies everyone! "Hasdata" works fine when my subreport is in the report footer on main report. But my problem is that I dont know how to get SUM calculation in a textbox on a main report from subreports that are in part# footer on my main form. So subreport are not in page...

Try using "Can grow" and "Can shrink" in textbox properties.

Hi! I have a subreport in my main report footer. I would like to get the sum of the subreport values on the main report. I tried to type the following in the textbox controlsource on main report where I would like to see the total: =sum([subreportname]![textboxname]) but I get an error. Then I...

Many thanks!

Hello! I managed to show the data from the sub report on the main report. But the problem is that if sub report column I would like to use in calculation in main form is empty, I get an "#error" in my textbox. Now I tried nz, isnull, and combinations of the two that can be found in Access help...

Oh boy! This is awesome! Thank you!

Hi! I have report with a sub report in it. What would be the syntax to perform calculations on main report using data from sub report? For example: if I have a textbox TOTALSUB on sub report, and I would like to use that sub report total in a total for main report which is in a textbox...

I've solved it!

Hello! I'm trying to create an application which will print labels with information about parts. I have a quantity value how much fits in a box. Also, I have a value for entire quantity shipping. What I'm trying to to get is this - if my entire quantity is 90 and I can fit 25 parts per box...

Hi! I had to generate those records. Anyway, I figured it out but thank you on your response. Marko

Hi! Actually, you were very close :) It should say Like [Enter Program Number] This way if you want everything that starts with Argon, just type in dialog box argon* There was a very similar thread here Cheers!

Hello! I have a query that returns: Name Freq. John 10 Mark 10 Matthew 15 Luke 20 If my total number of pieces is, say, 100, then I need a query that will return values as in my example below using values in column frequency to fill out space between 1 through 100...

Thank you FoFa, works great! Marko

Great Pat! Thanks!

Right! :)

Hi! In criteria where you ask for department type: Like [Enter Department] This way when he prompts you, you can type * and this way youll get all the results. Cheers! Marko

Hello! How can I make a query which will, as results, return all the rows which are not identical in joined fields? Example: Tables in the query: Table1: John Luke Matthew Mark Table2: John Luke Results: I get: query1: John Luke...

Anybody?

Hello everybody! I have a query that returns: Description Process Technique Frequency Sheet 11Ga Krautkramer 10 Master 36x85" Micrometer 15 . . . The application is about checking certain characteristics for parts in...