Get Value from Previous Record for this record
Tech-Archive recommends: Fix windows errors by optimizing your registry
Is it possiable to have a iif function in a query where it looks at
the next record. for example if I run the query which lists years
and
if the results in record 2 equals the result in record 1 then it
displays an X.
.
Relevant Pages
- RE: Weird Problem with a Subreport
... Ok for the sorting i will try to explain it to you. ... query by writing the SQL I didnt include the Place holder field, ... Do you have a text box in the Goup Header? ... I have a header of shutdown in front of the whole list but the two lists ...
(microsoft.public.access.reports) - RE: Weird Problem with a Subreport
... Now I need to make reports for the lists for all ... a save as for the reports and just change which query they are getting the ... and used sorting and grouping to sort by the placeholder and all is well!!!! ... Do you have a text box in the Goup Header? ...
(microsoft.public.access.reports) - RE: Weird Problem with a Subreport
... Do you have a table that lists all the tests for the year by month? ... you could filter your query by the month identifier. ... and used sorting and grouping to sort by the placeholder and all is well!!!! ... Do you have a text box in the Goup Header? ...
(microsoft.public.access.reports) - Re: Question on joins
... single-table FROM clauses and infixed notation in all my multi-table ... Both my first step (attempting to find the join conditions in the ugly ... comma-seperated query) and your show clearly ... and WHERE clause lists to take advantage of the Law of Proximity in my ...
(microsoft.public.sqlserver.programming) - RE: Weird Problem with a Subreport
... Ok for the sorting i will try to explain it to you. ... query by writing the SQL I didnt include the Place holder field, ... Do you have a text box in the Goup Header? ... I have a header of shutdown in front of the whole list but the two lists ...
(microsoft.public.access.reports) |
|
