Search results

Well thanks very much Pat, yes a simple cross tab query was all that was needed !!! Great stuff!!!

Ok I will try a different approach I am trying to lookup the question number so to return the answer from a query. On my form for the answer to question 1 I have tried this in a bound field DLookup("[Drawing Enclosed]", " QryCDMAnswerReport ", "[ProjectNumber]="[Forms]![Main Form]![PN]) &...

ummm ok my report will look like this:- Question 1 = ?? some other text goes here and maybe questions 2 is over the right hand side of my report say here-------------------------------------------> Question 2 = ?? So my report returns data from a qry showing 20 question and...

I have a query that returns 10 questions with the answers previously given by the users e.g. Question ID Answer 1 Yes 2 No 3 N/A etc.. On my report I need to collect this information not as a list but is...

ok i have this sorted now thnaks very much for your help

Well I have tired to do it this way but when I add my sub reports to the main report the page breaks in the sub report do not seem to be active and I have tried removing them and adding them whilst in design of my main page How can I force the page break on the sub report is there another method...

Can someone please explaing why the maximum height restricted to 55cm? I can only ever get 3 pages on a report and have a 17 page report to design is it possible to do 17 page reports in one report or do I have to creat a number of reports? thanks

I have 2 problems I would like some advise on:- 1. Is the maximum report length 55cm I have tired alsorts of ways to extend this length properties etc.. and pulling down the back ground but cannot get it to go past this size? If this is true I presume for my 17 page report I will have to create...

Got it sorted now thank you had to use this for combo box 1 always get mixed up as to when to use Me! or Me. I generally jsut try both until it works lol but much appreciated. Private Sub Pipe_Cat_AfterUpdate() Me![Sch Size] = " " Me![Surface Cat] = " " Me![Sch Size].Requery Me![Surface...

This look very helpful to me as it clears the fields in the combo box but will it also clear the field from my table that is used to populate the form when it opens? Basically I have combo boxes attached to the table data and a separate table is used to populate the list in combo boxes i.e. I...

I have read the cascading combo box solution and would like to know if this would help me with my specific solution. I have a subform that is used to populate a table which is later used to cost each row by linking to a costing table (see later). 3 off the columns in this form have been set...