Queries and SQL

[J]

I have a form that displays Project numbers at the top of the form and
displays information about that project number below. It is possible
that a Project Number can be there more than once on a form. My
problem is being able to get it so that all the information regarding a
particular Project Number appears all on one screen rather than
appearing randomly throughout the records. I was told that I could use
a query or an SQL statement to fix the problem and also something
called a UNION SELECT query. If anyone could explain how I would
implement these methods it would be greatly appreciated. I am also
using a subform if that would have anything to do with the solution.


For Example:


Right now my form displays like this:


A01
Information Here


A02(New Record)
Information Here


A01(New Record)
Information Here


But I want it to display like this:


A01
All information on A01 here


A02(new screen)
All information on A02 here


A03(new screen)
All information on A03 Here


etc

 

[Michel Walsh]

Hi,


If you want to "group together" similar records, such as those speaking of a
given Project, ORDER BY could help in that kind of grouping: if there are
10 records about Project ABC, then all the 10 records will be "together",
but still in a group of 10 records, rather than being almost randomly
located in your recordset. You can ORDER BY with a query that will be used
as records source for the form, or through the form standard menu.



Hoping it may help,
Vanderghast, Access MVP