Creating Balance sheet type report

[dipankarmaitra]

Hello All,

I have to build a report through Visual basic and Ms-Access Database. A field in the database has a value 0 or 1.
I want to print the accounts on the left hand of the page if the value is 0 and on the right if the value is 1.

The report might show like this :

Field=0 Field=1
abc def nep qer
ffr hhy ddd ggg

I hope you understand my problem. It is also necessary to invoke this report from visual basic, depending upon certain parameters (eg, id and two date fields)

It will be very kind if someone helps me in this issue.

Thx in advance
Dipankar

 

[AndrewBaines]

You need to create two formulae:
formleft - if value= 1 then blah else 0
formright - if value = 0 then blah else 0

Need some more info on your VB requirements. Take a look at the RDC first though