Creating Report with Table Format

atzdgreat

Member
Local time
Today, 06:39
Joined
Sep 5, 2019
Messages
42
hi, it is my first time to use reporting in access. is there any way i can make a report as per attached image? thank you.
 

Attachments

  • Test Image.JPG
    Test Image.JPG
    57.9 KB · Views: 184
hi thank you for your reply.

here is my sample field in my table.

Code_Num
Code_Details
First_Off
Sec_Off
Third_Off
Fourth_Off
Disp_Table

datas are stored in table as per attached image. now in field Disp_Table, if there is data "Display". then the table will display in report.
 

Attachments

  • testing.JPG
    testing.JPG
    32.2 KB · Views: 171
if ever i am going to reconstruct my data table, is there any possible i can achieve the report? thanks
 
Like Pat, I am confused by data structure.

Can arrange controls so the Penalty fields are below Code_Num but then the labels will show under every code even if there is no data.

How high do those code numbers go? You should be aware that 10.0.0 will sort before 2.0.0; 1.10.0 will sort before 1.2.0, etc.

Where does "Blah blah blah blah blah" come from?

Most anything can be done with enough code and this might require some very creative coding.
 
Last edited:

Users who are viewing this thread

Back
Top Bottom