Gud Day to All,

I have a query "Activity Query" which i selected from two tables, this query have 12 fields. I would like to format my report like this:

field1 = 1

field2, field3, field3, filed4,field5, field6




field1 = 2

field7, field8,field9,field10,field11,field12


I've try to group field1 but i cannot come up with this format..... anyone knows this, i need your help

thanks.



:(

So, for the first record, you want to display fields 2 through 6 and for the second record, display fields 7 through 12?

hi pdx_man,

it should go like this, field1 = activity_type


activity_type = "chargeable"

act_date file_number report_type remarks time_spent


(all records which has activity type = "chargeable" will fill this fields display here )


total:time_spent
__________________________________________________ _


activity_type = "non-chargeable"

expense_type expense_remarks from to amount

(all records which has activity type = "non-chargeable" will fill this fields and display here )


total: amount


note: should be display in a single report

So then, you have a group for Field1 with the Header and Footer properties set to true. Then, you put the Field1 control in the Header, the fields you want displayed in the Detail section and then a text box with [b]=Sum([TimeSpentField]) in the Field1 Footer section?

This should work.

Yeah i've got what you mean thanks,

but how about on the second part,where activity_type = " non-chargeable" ; if we analyze it, i have different fields to be displayed on the detail section?

i know this is tricky.

thanks,

kulas:)

So then, what does say, field4, contain for non-chargeable records? What does field9 have for chargeable?

Well, anyway, you are going to have to have both controls in the detail section sittin right on top of each other. Have the higher # controls Visible property set to No. Then, in the Group Header OnFormat event, have code like this:


If Me.Field1 = "non-chargeable" Then
Me.Field2.Visible = True
Me.Field3.Visible = True
:
:
Me.Field7.Visible = False
Me.Field8.Visible = False
:
:
Else
Me.Field2.Visible = False
Me.Field2.Visible = False
:
:
Me.Field7.Visible = True
Me.Field8.Visible = True
:
:
End If

hello pdx_man......your the man....thanks a lot .... it works.


by the way, i have another question... i'm trying to import dbf files from fox pro, but it gives me an error.

do you know any procedure how??


thanks again....you make my day smiles

:)

Forget my other question......i've done it.

i'd tried to link first the dbf files then re index....afterwards i'd tried to import then it works.

thanks anyway,
kulas
:)