Queries and SQL

  • Thread starter Thread starter J
  • Start date Start date
J

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
 
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
 
Back
Top