Database/Table question

  • Thread starter Thread starter Bamarama007
  • Start date Start date
B

Bamarama007

I have a question that I am not sure how to word. I need to have a table that
contains records from a Access DB. Instead of having all the records go down
the page, I need them to be viewed in 2 rows. The table is a list of points,
and I want it to list names and points across from each other, rather than a
list that is verticle. Here is an example of what I wold like it to look like.
http://www.gig-golf.com/ZSL/zslexample.asp Can this be done?? I am organizing
a golf league, and need to show matches based on the point total, but have them
list the way I have shown. I have read a page about having 2 columns, but this
won't help me. Basically, I need the list to alternate back and forth in
columns. I am using FP 2002, and MS Access 2002 ( I guess, it is from the
office XP disk). My server uses ASP scripting with SQL. Hopefully, this is all
the info needed to try and help me with this question.
Thanks a bunch in advance.
Jeff
 
Ok. I have looked at that. It shows me that the right column shows info that is
for the same person on the left column. Am I missing something? I need the lef
to be a different person than the right. The right column should show the
person and the score that is directly under the person on the left column when
sorted by points. then in the next row, the left should be the person that is
directly under the upper row right column in the points sort. Does this make
sense??
Jeff
 
I guess to make this simple to say what I want, I will put it like this. The
left column, starting at number 1, should display every other record from the
DB, while the right column, starting at number 2, should display everyother
record in the DB. So the left would be the odd numbered resuts, and the right
should be the evened numbered results. Does that help?
Jeff
 
Back
Top