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