I currently have a reports menu on my db that allows employees to use ComboBoxs to filter for accounts based on Program and Manager. Everything functions correctly, but my problem comes from how the accounts are displayed when there are multiple ones being pulled onto the form.
In its current state, it just shows 1 account but then combines all the data on that single form..
--------------------------------------------
Account 1
data1 data2 data3 data4 data5
data1 data2 data3 data4 data5
data1 data2 data3 data4 data5
--------------------------------------------
Ideally, I'd like to have it pulled like this..
--------------------------------------------
Account 1
data1 data2 data3 data4 data5
Account 2
data1 data2 data3 data4 data5
Account 3
data1 data2 data3 data4 data5
--------------------------------------------
Is there any easy way to break up information on a form based on a specific field (ie. account #)? The filters are supossed to get it down to a specific program and manager, but then i'd like to be able to see all the accounts under that criteria. It just isn't developing the form correctly yet.
In its current state, it just shows 1 account but then combines all the data on that single form..
--------------------------------------------
Account 1
data1 data2 data3 data4 data5
data1 data2 data3 data4 data5
data1 data2 data3 data4 data5
--------------------------------------------
Ideally, I'd like to have it pulled like this..
--------------------------------------------
Account 1
data1 data2 data3 data4 data5
Account 2
data1 data2 data3 data4 data5
Account 3
data1 data2 data3 data4 data5
--------------------------------------------
Is there any easy way to break up information on a form based on a specific field (ie. account #)? The filters are supossed to get it down to a specific program and manager, but then i'd like to be able to see all the accounts under that criteria. It just isn't developing the form correctly yet.
