Report in Label format (1 Viewer)

Local time
Today, 10:45
Joined
Oct 7, 2016
Messages
43
I have created a Report in Ms Access File ( MDB) as attached, Wherein report is in Row wise format , but I want it in Column Format i.e in Label format
In Three Columns (Sector -1 , Sector -2 ,Sector -3 ) in Small it is mentioned as SEC-1 similarly for all sectors.

Two Class are there ( Crew and Tech_Crew)
Meals Are in VEG and NON VEG Format.

Kindly Suggest how to prepare Report (Actual Report) as mentioned in Images






1_SW_Access_Report.JPG
2_Actual_Report.JPG
 

Attachments

  • SW_Report.mdb
    608 KB · Views: 260

Uncle Gizmo

Nifty Access Guy
Staff member
Local time
Today, 17:45
Joined
Jul 9, 2003
Messages
16,244
Wherein report is in Row wise format , but I want it in Column Format

Do you mean like this?

 
Local time
Today, 10:45
Joined
Oct 7, 2016
Messages
43
Do you mean like this?


UNABLE TO UNDER STAND.

Kindly explain in detail , I have already attached Ms Access File above.
 

mike60smart

Registered User.
Local time
Today, 17:45
Joined
Aug 6, 2017
Messages
1,899
I have created a Report in Ms Access File ( MDB) as attached, Wherein report is in Row wise format , but I want it in Column Format i.e in Label format
In Three Columns (Sector -1 , Sector -2 ,Sector -3 ) in Small it is mentioned as SEC-1 similarly for all sectors.

Two Class are there ( Crew and Tech_Crew)
Meals Are in VEG and NON VEG Format.

Kindly Suggest how to prepare Report (Actual Report) as mentioned in Images






View attachment 93120 View attachment 93121
Hi
The attached is one way of doing this.
I created a query for each Section ie Sec-1, Sec-2 and Sec-3
I then created a Report for each Section
Then the Final Report has all 3 sections

Look at the rptAllSections and see if this suits.

Please also study the relationship diagram - I changed how the tables were related so that each relationship was on a Number Data Type and not Text.
 

Attachments

  • SW_Report.zip
    80.2 KB · Views: 269

arnelgp

..forever waiting... waiting for jellybean!
Local time
Tomorrow, 01:45
Joined
May 7, 2009
Messages
19,169
my first attempt was to create a Sub-report (see report1).
i did not continue that path, instead go for the easier path, Report2
using Dlookup().

see Report2 in print preview.
 

Attachments

  • SW_Report.mdb
    2.5 MB · Views: 275
Local time
Today, 10:45
Joined
Oct 7, 2016
Messages
43
Perfect Arnelgp, Appreciate your efforts

Reference your Attached File Report2,

On Page one CREW -Non Veg and Veg data is data is visible but TECH CREW -Nov Veg is Blank.
On Page Two CREW -Non Veg and Veg data is data is Blank but TECH CREW -Nov Veg data is visible.


Please suggest that the Entire data should be in One Page : CREW -Non Veg & Veg data data and TECH CREW -Nov Veg Data visible.
 

mike60smart

Registered User.
Local time
Today, 17:45
Joined
Aug 6, 2017
Messages
1,899
The rptAllsections in my example is all on one page?
 

Attachments

  • rptAllSections.JPG
    rptAllSections.JPG
    95 KB · Views: 182
Local time
Today, 10:45
Joined
Oct 7, 2016
Messages
43
use Report3
Perfect,

Adding one more query :


Table : dbo_Menu_Sectors_Mast
Please create a Form based on above mentioned table.

Please suggest : VBA CODE On Modification of any form's Field , It will store modification Data and Time in the Filed dbo_Menu_Sectors_Mast!Menu_Modified
 
Local time
Today, 10:45
Joined
Oct 7, 2016
Messages
43
Perfect,

Adding one more query :


Table : dbo_Menu_Sectors_Mast
Please create a Form based on above mentioned table.

Please suggest : VBA CODE On Modification of any form's Field , It will store modification Data and Time in the Filed dbo_Menu_Sectors_Mast!Menu_Modified
arnelgp, Awaiting for your reply
 

Users who are viewing this thread

Top Bottom