Search results

Was only way I could get it to work with proper page layout of form like such Heading Description Description Materials Materials And page layout sticking

cheers for looking at any input appreciated :) only been using access for 2 weeks so go easy on me :P think ive sunk 80-90 hrs into it so far tho :/ it's my new WoW learned SOOO much from here and cpl CD911 courses big thanks :) Report Jobs and Invoice are main ones form is MainForm rather...

have Forms setup with two Subforms if for some reason the 2nd one has no data in it i will get a blank report if i put anything in the 2nd subform at all it works fine any ideas ?

interesting error in my Subreport now :/ seems to be Quadrupaling any result

your post 11 you mean a Sum*Quantity query ?

Hmm i get an error as soon as i move it to the Page footer but works fine in the report footer

yeah i had it in the Page Footer but it has to be in the Report footer

ah i see it HAS to be right at the footer

hmm still seem to be just generating an error spot anything ?

would i be correct in assuming that =Sum([Price]*[Quantity]) would capture teh results of a varing amount of =[Price]*[Quantity] in a column ? cheers for help too btw :)

ok i see what you mean but what if i want to then add the results of that box to another ? say i have 2 running Sums that i want totaled

given Price and Quantity are Control Sources for those fields i am assuming you are saying to relabel thier name under "other" property on the report ?

have an invoice report set out like so Heading Description............Price....Quantity...a text box with "=[Price]*[Quantity] however getting a grand total seems a problem my totals tool only allows me to get a count records since sum is greyed out any ideas ?

yeah thats how i was doing it just wondered if was way to do from one report for layouts sake

hmm been through that can sort to make em stack up and appear side by side Materials Job Description Materials Job Description which is group on Materials and removal of Detail Area but not Materials Materials Job Description Job Description

strike that i got it working with a single macro on the subform On Current Requery the field macro Now to sort out my Report problems been 18 hrs straight on this Db better get some shuteye :P

i kept getting errors and interference with Me.CascadedComboName.Requery or cmbSecondComboBox.requery or docmd.requery "cmbSecondComboBox" mostly with unrecognized me. errors and anything on the "On Change" line immediatly threw up an error but i got it working with macro on After Update...

Trying to set up a report but having a few probs with design set up form like such atm ; Heading Job No Job Performed Materials Job Performed Materials Footer but im trying to get it to do like so ; Heading Job No Job Performed...

cheers for reply :) hmmm im using; SELECT Description.[Price@], Main.JobNo, Description.JobNo FROM Main INNER JOIN Description ON Main.FormNo = Description.FormNo WHERE (((Description.JobNo)=[Forms]![MainForm]![JobNo])); but setting it to the on change event of my combo box in the subform...

have a problem where the query works but the results dont refresh later ie queries all the items in (storeA) on Main Form for the combo box in Subform but when i move to next form/s with (StoreB) the combo box results still equals results of (StoreA) if open fresh and go to a form with...