Search results

Hi On your report you have several area's:- report Header section, Page header section, detail section, page footer, and report footer. I'm gurssing the "names" are in the detail section, to do what you want you need to put "names" into the page header. This will group records by name and...

Hi All i realise this may be a daft question but i need to create a report which lists grouped by name modules completed ie: Name Modules completed Fred Bloggs Module 1 Module 2 Module 3 Jim Smith Module 1 Module 2 Module 4 the names aRe held in one table/ form...

Hi All I realise i may have posted this before but I seem to be unable to get anywhere with my problem and have to have something ready for a major meeting on Saturday (i hope).:eek: :confused: I need to be able to select a row of data in the form "this years modules" (activated from the...

Hi all Can anyone help me to paste/copy a whole row from a combo box eg combo box lists [module],[date],[course director] sub form has the same fields i want to insert [module[, [date] and [director] from the combo box selection into subform. at the moment I select the module and that...

Dear Mark Many thanks for your reply, Whilst you are entirely correct, it does pose me problems namely; 1/ inserting more than on field into the table (matching field to field) 2/ when i search the data later for reports etc, the resultant displayed is the ID number or i get a data tyep...

using if Thank you very much, i jusy could not work it out

Hi I need help, badly I have a report & query which needs a calculation performing if another field is set to "true" and cannot seem to get it to work. EG total cost:= if [3rd party accedent]="true",([paint cost]+([labour rate]*[hours])+[parts cost]). Please help I'm a newbie and I bet i've...

Hi all I need help I am creating a training database for cambs scouts. The main records form has the persons details (name etc) called Main trainind records. and a subform as a datasheet (called leader training undertaken), which holds the courses the person has undertaken (obviously). My...

Thanks I'll take your advice, as a report would do the job well enough. Again many thanks Row

Many thanks for your help. Is there some way this can be done on Forms?

Hi Guys I need to create a method of calculating -week number,hours worked per week and a leiu hours total. Explanation Users enter their worked hours per day. I need to calculate the total hours worked per user per week and if this is greater or less than their contracted hours a record of...