List Multiple Records on Form

[mcupito]

I'd like to list the multiple records on the form. I'll attach images because it's just easier that way.

On the form, instead of the row selector, I'd like it to just list the different Totals. I understand I organized them as Tabular in the design view, is that preventing this change?

Thanks..

[imgnothumb]http://bytes.com/attachment.php? attachmentid=73 06[/imgnothumb]

[imgnothumb]http://bytes.com/attachment.php? attachmentid=73 07[/imgnothumb]

[zmbd]

I've looked about a dozen times at your question and I just don't have enough information.
The details section should be listing a record for each entry in your recordset.

So,
What I think we need to see is the SQL of the underlying recordset that the form is using.

When you post the SQL, please select the text and format it using the [CODE/] button in the toolbar.

(^-^)
z

[mcupito]

Hey, Z - sorry for the delay and thanks for your response. Here is the SQL:

SELECT PlanTbl.PlanDesc, Sum(AwardTbl.AwardUnits) AS SumOfAwardUnits, Sum(AwardTbl.ForfeitedUnits) AS SumOfForfeitedUnits, Sum(AwardTbl.PaidOutUnits) AS SumOfPaidOutUnits, Sum(NZ([AwardTbl]![AwardUnits],0)-NZ([AwardTbl]![ForfeitedUnits],0)-NZ([AwardTbl]![PaidOutUnits],0)) AS OutstandingUnits, AwardTbl.EmployeeID, PlanTbl.PlanID
FROM PlanTbl RIGHT JOIN (AssociateTbl RIGHT JOIN AwardTbl ON AssociateTbl.EmployeeID = AwardTbl.EmployeeID) ON PlanTbl.PlanID = AwardTbl.PlanID
GROUP BY PlanTbl.PlanDesc, AwardTbl.EmployeeID, PlanTbl.PlanID;

If you need more clarification on what I am trying to do, please let me know! Thanks!

[zmbd]

I can appreciate the delays... if you haven't noticed, I've been playing catchup, often on page three of the new posts as of late... (and the time tonight is quite late locally too).

So forgive me a tad as I've not taken a very detailed look at the SQL yet... I'm on my way to bed. (z.z)

When you run this as a standalone query, how many records are being returned? By standalone, I mean, if you open a new query in design mode, switch to SQL view, cut-n-paste this in, and finally run it - what do you get?

(^-^)

[mcupito]

I get the sum of each award, by description, by employee ID. It is finding all of the correct information, but I am not sure how to enable it to show up as a list on the Form instead of the user having to page through, if that makes sense.

Thanks

[zmbd]

Open the form in design view
Open the properies (just right click on any control and properties(
In the properties pane, dropdown list at the top, find the "form" entry and select it
Click the format tab
What is the entry in the default view.

If "single form"
set to "Continuous Forms"

[mcupito]

That's it! Thanks so much!