424,303 Members | 1,366 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,303 IT Pros & Developers. It's quick & easy.

List Multiple Records on Form

100+
P: 294
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..



Attached Images
File Type: jpg Form1.jpg (21.9 KB, 3099 views)
File Type: jpg AwardSum.jpg (80.2 KB, 2944 views)
Nov 13 '13 #1

✓ answered by 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"

Share this Question
Share on Google+
6 Replies


zmbd
Expert Mod 5K+
P: 5,285
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
Nov 13 '13 #2

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

Expand|Select|Wrap|Line Numbers
  1. 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
  2. FROM PlanTbl RIGHT JOIN (AssociateTbl RIGHT JOIN AwardTbl ON AssociateTbl.EmployeeID = AwardTbl.EmployeeID) ON PlanTbl.PlanID = AwardTbl.PlanID
  3. GROUP BY PlanTbl.PlanDesc, AwardTbl.EmployeeID, PlanTbl.PlanID;
  4.  
  5.  
If you need more clarification on what I am trying to do, please let me know! Thanks!
Nov 15 '13 #3

zmbd
Expert Mod 5K+
P: 5,285
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?

(^-^)
Nov 18 '13 #4

100+
P: 294
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
Nov 18 '13 #5

zmbd
Expert Mod 5K+
P: 5,285
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"
Nov 18 '13 #6

100+
P: 294
That's it! Thanks so much!
Nov 18 '13 #7

Post your reply

Sign in to post your reply or Sign up for a free account.