Search results

I have tried this but it puts a break after each record rather than each students results. For instance if you refer to the attachment, I put a page break at the end of the detail section and it put a page break after each instance of an exercise. There are approx 12 exercise results per...

Okay I have tried again and the Or does work. Looks like I was typing my search criteria incorrectly..oops. What I need now is for each record to be printed on a separate page in the report. Currently Both students are printed on the same page in the report. How can I get the report to print...

Sorry I have tried that but it does not work

Sorry I have tried that and that does not work

Hi I need to be able to print records for certain students showing their best and worst results for each exercise. Must be printed in portrait A4. Each student must be on a new page. I am trying to create a query which will find the results for studentID AA111 and DS1119. For each student: ·...

Thank you, phew what a struggle! the(2) needed changing to (1) as well. Cheers you have been a great help. Until next time! Darth

On the form it diplays #name error for the hidTxtControl

Bizarre, it now leaves the month and testcomments field blank in the tblFitness test after executing the append query. hidTxtControl control source: =[me].[cboMonth].[column](2) Ammended query: INSERT INTO tblFitnessTest ( TestID, TestMonth, TestComments ) SELECT...

Appen query: INSERT INTO tblFitnessTest ( TestID, TestMonth, TestComments ) SELECT [Forms]![frmNewTest]![myFitnessTestID] AS Expr1, [Forms]![frmNewTest]![cboMonth] AS Expr2, [Forms]![frmNewTest]![txtComments] AS Expr3;

INSERT INTO tblFitnessTest ( TestID, TestMonth, TestComments ) SELECT [Forms]![frmNewTest]![myFitnessTestID] AS Expr1, [Forms]![frmNewTest]![cboMonth] AS Expr2, [Forms]![frmNewTest]![txtComments] AS Expr3;

I'm not entirely sure what you mean. You will have to break it down in baby steps for me. I have the append query running on the button.

Where do I put that? Sorry if I come across as an amateur...I am.

Unfortunately I need the data in the table to be stored as a month. This is the predicament I am in.

The only problem I have with this is that when the data is appended to the tblFitnessTest the fitnessTestID is fine but when month is added it is added as a number rather than "January" for example.

Row source is a list of: January February March April May June July August September October November December

Hi I have added an image file to enhance the clarity of what I am trying to achieve. Please have a look and get back to me. Thanks Darth

I have tried that, but it is only the month that exists in the text field. It is not a complete date. January February March ... Which ever month is displayed in the field needs converting to the corresponding value in another field.

Hi I have a txt box on a form in which I type the month of the year e.g January, February etc. What I am having problems with is in another field I need to convert this month to it's corresponding value e.g. January will be 1, February will be 2 and so on. I have hit a brick wall, please...

Thanks will do .

Hi Thanks for the response it worked!. When I used expression builder to create the append query I'm pretty sure I didn't add FROM tblFitnessTest. How did this get there? Thanks Darth Sidious