Report showing blank Values at the end of a report

[mack1Quanta]

I have a signature chart with a list of employee names, and I wanted to add blank values to populate at the bottom for any future people we hire. i started to create blank records of employee information, so the report would recognize not-null values and think to put them in descending order (at the bottom). But of course its hiding duplicates. So then i tried to unhide, but it for some reason is still hiding. So i made employees 1-10.... So with some tinkering, i realized how long it was taking, and i would like to see if someone knew of a faster way. if not, i will just trial and error each chart and create random employees so it will work the way i want it to look.

 

[GohDiamond]

I came in after looking at this 3 times along with about 30 other viewers. Frankly, without some screenshots I can't visualize what you're getting at. Why would you want blank records or duplicates in an Access database. Those are some of the specific things that access strives to eliminate. Are you trying to apply Excel thinking to Access? because in many instances that won't work since Access has a different set of rules for handling data.

Back it up and take a run at it again. Maybe if you clarify and send a screen shot the clouds will lift and we can see what you're trying to do.

Cheers!
Goh

 

[arnelgp]

see this:
http://www.vb123.com/pages/kb/200310_dl_pad.aspx

or you may upload ur db and i will do it for you.

 

[mack1Quanta]

LOL, i probably am trying to do something that is probably easier to do in excel, but i figured I would ask since i prefer using access.
Basically, I have all peoples names in a table, and all SOP's list and descriptions in a table. Everyone currently hired is being filtered by a query as 'employed' and each person is assigned a department; office, lab, management, etc. Each department has a relationship to the person and the SOP they need to read. So when i run my report each person that needs to read a SOP for their department will show up. Upon distribution of SOPs, once employees have read the SOP they will have to sign the printed report manually in the SOP binder.
So then since the chart will already be printed, any new employees we hire in the future, i can just manually write their name at the bottom, because there will be blank employee info . The 'capture' document i attached, i put numbers in where the names go, but would rather not see anything in there. I just wanted you to see what i was trying to do.
The access report is a screen shot of my designview, each employeeinfo[first name] header, has a background alternating darker 5%, and i was hoping to see the alternate grey and white background to show at the bottom of my report. I just cant stand excel, but i think the alternate background looks better, instead of a 'table' boxed lines from excel like we have done in the past. :banghead:

Thanks for the response! i am a self tought access person, so i am still learning as i go, so if this is a stupid question, feel free to let me know!!