Grouping in Forms Like In Reports

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a query with the following SQL:

SELECT Addresses.ListMember, Addresses.Priority, Addresses.AddressID,
Addresses.LastName, Addresses.FirstName
FROM Addresses
GROUP BY Addresses.ListMember, Addresses.Priority, Addresses.AddressID,
Addresses.LastName, Addresses.FirstName
ORDER BY Addresses.ListMember, Addresses.Priority DESC , Addresses.LastName,
Addresses.FirstName;


If I do a report, I can get it to group on List Member, then Priority, then
sort by Last Name, then First Name. I am having a hard time duplicating this
in a form.

What I would like to do is have a form on the left side of my screen with
this "report" in it of all the current records in the Addresses table. On the
right side of the screen, I would like a form used for data entry (already
created and like I want it). I know this is a sub-form scenario and I am
pretty confident in how to get the Right "pane" to follow the left pane when
a name is clicked on, but I am having trouble creating the left pane.

Does anyone have any ideas?

Thank you in advance for any help you can provide.

Regards,
Keith
 
Texernie1 said:
I have a query with the following SQL:

SELECT Addresses.ListMember, Addresses.Priority, Addresses.AddressID,
Addresses.LastName, Addresses.FirstName
FROM Addresses
GROUP BY Addresses.ListMember, Addresses.Priority, Addresses.AddressID,
Addresses.LastName, Addresses.FirstName
ORDER BY Addresses.ListMember, Addresses.Priority DESC , Addresses.LastName,
Addresses.FirstName;


If I do a report, I can get it to group on List Member, then Priority, then
sort by Last Name, then First Name. I am having a hard time duplicating this
in a form.

What I would like to do is have a form on the left side of my screen with
this "report" in it of all the current records in the Addresses table. On the
right side of the screen, I would like a form used for data entry (already
created and like I want it). I know this is a sub-form scenario and I am
pretty confident in how to get the Right "pane" to follow the left pane when
a name is clicked on, but I am having trouble creating the left pane.

Does anyone have any ideas?

Thank you in advance for any help you can provide.

Regards,
Keith
Click to expand...

Does anyone know if this is even possible? If it is not, I will explore an
alternative.

Thanks in advance.

Keith
 
Back
Top