maxa27
|
Posted: 04/18/2004, 12:22 PM |
|
Hi,
I want to make 3 gride.
Database have 200 records.
In first i want to display last record, number 200.
That is easy i select order desc. for that grid.
In second grid i want to display record number 199.
And in third grid i want to display record number 198.
I dont know how to do this???
I thin i have to do something like recordcount - 1 and recordcount - 2 but i dont know where to do that.
Using ASP and mdb.
Thanxs in advance,
maxa
|
|
|
peterr
Posts: 5971
|
Posted: 04/18/2004, 1:52 PM |
|
On the 2nd Grid create a Where Parameter with Type=Expression, Condition=<> , and Parameter Source=Grid1.Label1.Value.
On the 3rd Grid create two Where Parameters, one with Type=Expression, Condition=<> , and Parameter Source=Grid1.Label1.Value ; second one with Type=Expression, Condition=<> , and Parameter Source=Grid2.Label1.Value.
(replace Grid1, Grid2, Label1 with own grid and control names)
Hope this is sufficiently clear or you get the idea, otherwise please let me know and I'll describe each parameter in more detail.
Let me only explain that I recommend displaying all records in reverse order while at the same time specify in the 2nd and 3rd grid's Where statements to skip records already shown in the previous grid(s).
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
maxa27
|
Posted: 04/19/2004, 3:05 PM |
|
Thank you peterr.
I have make 3 gride and put order desc.
On the 2nd Grid:
createing a Where Parameter with Type=Expression, Condition< , and Parameter Source=Grid1.Label1.Value.
On the 3rd Grid:
createing Where Parameters with Type=Expression, Condition< , and Parameter Source=Grid2.Label2.Value
I i get exatly what i need and working perfect.
Thx again.
|
|
|
|