Fixed Format In The Report's Detail

[mykil]

The code does not handle Null. So you will need to get query to get all the Null records for each group and join (i.e. using UNION) it to your current query.

Uhmmm.Can you give me the Direction if that's okay to you..because I don't know where to start

. I just want the format of the section to be copied in the second column as what you have shown in your posted sample DB...

 

[vbaInet]

What exactly did you not understand? Ask specific questions.

 

[mykil]

What exactly did you not understand? Ask specific questions.

OK.. This is what I don't understand.

get query to get all the Null records for each group and join (i.e. using UNION) it to your current query.

Can You explain it..I'm working now with my report for 1 week but no accomplishment..I will attach my stripped DB if you want to take a look and give solution to my problem...Thanks

 

[vbaInet]

Ok, go ahead. Let me see your db.

Note: We're here to advice, not just to give solutions.

 

[mykil]

Ok, go ahead. Let me see your db.

Note: We're here to advice, not just to give solutions.

Thank you..Here's my DB..I just wanted to have the column of my report fixed for all records. The report should be 2 columns and 2 rows only for an specific student..

 

[vbaInet]

You have not implemented my code anywhere in your report.

 

[mykil]

You have not implemented my code anywhere in your report.

Oh!!!I'm sorry, posted the wrong one.

 

[vbaInet]

That is not the full code. If some code was not useful I wouldn't have included it in the database I uploaded. The grouping is relevant.

 

[vbaInet]

It seems you haven't explained yourself clearly. Do you want to print even numbers of columns on one page irregardless of StudentID or you want to print even numbers based on StudentID? Are you going to apply a grouping on StudentID?

 

[mykil]

That is not the full code. If some code was not useful I wouldn't have included it in the database I uploaded. The grouping is relevant.

OK. I have put the missing code. but it produced a runtime error: overflow..

 

[vbaInet]

Runtime overflow is because the variable is Integer but your StudentID is String.

A reply to my last question is needed to progress with this.

 

[mykil]

So, could you give me an advice or something so that I can solve this issue?Anything just to make my desired report format..

 

[vbaInet]

I cannot give you any advice if what your trying to do is not clear. You need to answer this question.

It seems you haven't explained yourself clearly. Do you want to print even numbers of columns on one page irregardless of StudentID or you want to print even numbers based on StudentID? Are you going to apply a grouping on StudentID?

 

[mykil]

It seems you haven't explained yourself clearly. Do you want to print even numbers of columns on one page irregardless of StudentID or you want to print even numbers based on StudentID? Are you going to apply a grouping on StudentID?

Sorry. I did not saw it..Ok.Yes, want to print even number of columns on one page not based on StudentID but on YearLevel. In my form I have value list for YearLevel: "First Year" "Second Year" "Third Year" "Fourth Year" ONLY.So, If the Student has the record from First Year to Third Year not including Fourth Year the report must have added an empty section..I don't want to apply groupings on StudentID.. I think i should have added another field, but still don't know what it is. Do my answers clear?

 

[vbaInet]

That's clearer. So you are not going to add any grouping at all right?

 

[mykil]

That's clearer. So you are not going to add any grouping at all right?

Yes, I just want to add an empty section to my report if the YearLevel is from "First Year" to "Third Year"

 

[vbaInet]

It would make more sense if you add a group and print each group on a separate page. Or you don't want this?

Will the fourth year always be on the last page?

 

[mykil]

No, I don't like but if it needed then it should... Yes the fourth year is always on the last Column and row.. My desired report would have 2 columns and 2 rows only Just to have the First Year, Second Year, Third Year and Fourth Year has their own sections..

 

[vbaInet]

Your logic was not correct adn the data you gave me wasn't very helpful. You were supposed to group on StudentID because you have a heading per student - so this needs to print one student per page.

See attached.

 

[mykil]

Your logic was not correct adn the data you gave me wasn't very helpful. You were supposed to group on StudentID because you have a heading per student - so this needs to print one student per page.

See attached.

Thanks vbaInet .. May I ask again, For my other DB the StudentID changes every year.. StudentID for one student: for this year when he/she was first Year = 111111,and will change the next 3 years for Second, Third and Fourth = 121111,131111,141111... And,When opening my report I have required a Parameter Value to print Specific student only (Enter Surname for Student's Surname)(Enter Given name for Student's Given name)..So what would be the code for that? I have edited your attached DB but not the code so you would see my point if my explanation was not very clear.