Prev: Printing Checks from Access
Next: Syntax Error (missing operator)
From: Marco Pagliero on 15 Mar 2010 14:47
On 13 Mrz., 21:03, "Lars P. Magnussen" wrote:

> Yes, think I must do that to generate the lists and maybe afterwards remove
> the extra zeroes in production material.

I didn't mean that. SortField can be a temporary field that doesn't
appear at all in the reports:

select .... RefField, val(mid$(RefField,2)) as SortField, ... order by
SortField, RefField

That takes also care of the situations where you have C23A and C23B.
First  |  Prev  | 
Pages: 1 2
Prev: Printing Checks from Access
Next: Syntax Error (missing operator)