Report in Label format

[anandan.cr@gmail.com]

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

 

[Uncle Gizmo]

Wherein report is in Row wise format , but I want it in Column Format

Do you mean like this?

Reports Weaving Records – Nifty Access

www.niftyaccess.com

 

[anandan.cr@gmail.com]

Do you mean like this?

Reports Weaving Records – Nifty Access

www.niftyaccess.com

UNABLE TO UNDER STAND.

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

 

[Uncle Gizmo]

Kindly explain in detail ,

If you can use a three column weaving report, then that would be the simplest method. Otherwise you're into writing VBA I reckon.

 

[mike60smart]

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 93120View 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.

 

[arnelgp]

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.

 

[anandan.cr@gmail.com]

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.

Perfect Arnelgp, Appreciate your efforts

 

[anandan.cr@gmail.com]

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]

The rptAllsections in my example is all on one page?

 

[anandan.cr@gmail.com]

The rptAllsections in my example is all on one page?

I Appreciate your efforts and agreed in your suggested case All data is in one page , But for creating One Report I need create 3 Sub -Reports.

I am Looking for the Solution in one Report

 

[mike60smart]

Luck with your project then

 

[arnelgp]

use Report3

 

[anandan.cr@gmail.com]

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

 

[anandan.cr@gmail.com]

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