Search results

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

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

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

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

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

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

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

Hello everyone! I'm stuck... I have a form through which foreman makes a service request and that's stored in table tblexpenses. Now, serviceman on his form types the dates for which he wants to see jobs "posted" by foreman. That works fine, dates populate combobox with corresponding data...

Hello everyone! I'm trying to send results from my from to a table. Results on the from are from query and some are typed in textboxes. Those from query are in combobox and one is in listbox which is the result from the combobox choice. Here's the code I'm trying to get to work (I've found this...