report with grouping and combining fields.

[Junior1544]

I will give some back ground info befor i state how i want my report...

table structure is as follows.

Table One

fields name: Type & Desc:

DateOfWork DateField The date some work was performed.
Key Integer The work performed.


Table Two

Fields name: Type & Desc:

Key Integer (Primary key)
Short_Desc Text A short desc. used in form to select.
Long_Desc Memo A long description that will be put onto the report.


Now, how I want the report is like this:

Title Stuff.

Detail:
date all work done on this one date. using the long desc.



Thank you for any insight you might be able to pass to me... I have very limited knoldge about reports, but am faily good with vba to manipulate data...

Thank you...

--James junior1544@jmjpc.net
Life is change. To deny change is to deny life.

 

[Junior1544]

Ok, I was able to figure it out using grouping and a sub form... the only problem i have is one field shouldn't be repeated if it's the same... but i'm working on it!

Thanks Guys and Gals

--James
junior1544@jmjpc.net
Life is change. To deny change is to deny life.

 

[CosmoKramer]

James,

To not repeat duplicate fields, set the Hide Duplicates property for that field to Yes

 

[Junior1544]

I tried that, it doesn't seem to want to agree...

any other idea's??

--James
junior1544@jmjpc.net
Life is change. To deny change is to deny life.