Search results

Thank you. I will examine this later. The grades correspond the gaps so there will always be n-1.

Hi, Hopefully I can explain this clearly. I am building a student marksheet database. I have a student table and assessment table which are joined by student_assessment table where marks are stored. Each assessment can have different grade boundaries. So I have a gradeset table with the...

Only been on here for a few days but already learned loads. Thanks for all the help so far.

Sorry, scrub that, I just figured it out! got to use the IIf conditional. which gives a true or false value.

That seems to be what I want, but I can't quite work out the syntax. Here is my query that I am basing the crosstab on: I want both the columns at the end for each student for each test I have included a second table for the column headings in terms of sql this is: TRANSFORM...

I have a crosstab query of student marks for tests (test_id's are 1, 2, 7). In order to display the data I need to generate some calculated values from the score (grade and a unified weighted score). I don't think I can add these extra columns to the crosstab itself (correct me if I am wrong)...

Okay, fixed it by including all of the possible columns and then filtering the ones I need.

Sorry to bring it up again. This all works if there is only one page. However, if I have to go onto two pages and use the page with subreports I get the following error: It all works ok if I don't have parameters in my query and I use your original idea: With db.OpenRecordset("Select *...

Thanks again for your help

I tried the following and it worked ' open db and setup query Set db = CurrentDb Set qdf = db.QueryDefs("cxtPAG") qdf.Parameters("Forms!Form1!Combo4") = Forms!Form1!Combo4 ' open the crosstab recordset and loop though records to assign TextBoxes and Labels With...

Hey there, Thanks for your help so far. It all works with a hard coded crosstab. However, I'd like to pass parameters to the crosstab from the calling form. That works if I open the crosstab with the form open. But if I try to open the report the vba Report Open throws an error at the line...

Thank you so much, that is amazing.

Hi, I have a crosstab that produces a variable number of columns. [name] - - [skill1] - - [skill2] - - I would like to create a report based on this. This is to be printed to act as a tick list to be completed while assessing students. There are 36 different assessments which each have a...

Did you ever figure this out?

Okay, so I solved it like this: assign id numbers to the col headers in the crosstab query Then on the report based on the query do the following on load: Private Sub Report_Open(Cancel As Integer) Dim c As Access.Control For Each c In Me.PageHeaderSection.Controls If...

hmm, that is an annoyance. Ironically I am trying to bring a spreadsheet that (sort of) did what I wanted into my database so I don't want to have to export it back to excel. If I made the column headings the id number from the table that generates the full column titles could I use a lookup...

Hi, I have successfully generated a crosstab query to generate a report. The headings are rather long (up to 186 characters), the headings I am seeing in the query are truncated. Is there a limit? If so, is there any way around it? Thanks Martyn

Where have I named a column with the same name as the table? I had not noticed?

That is exactly what I was looking for, thank you

I realise that is nonsense, I just was wondering if there was some way of adding parameters? I can do it with a string replace: Me.RecordSource = Replace(db.QueryDefs("qrySelQuizQuestions").sql, "[quiz]", Forms("frmSelectQuestions")![cmbSelectQuiz])