Rob,

[Please trim your postings!!! -- 17KB is a little much]

> Database "C:\cashledger\CASHLEDGER.GDB"
>
> Database header page information:
> Flags 0
> Checksum 12345
> Generation 105
> Page size 4096
> ODS version 11.1
> Oldest transaction 653
> Oldest active 654
> Oldest snapshot 654
> Next transaction 655
> Bumped transaction 1
> Sequence number 0
> Next attachment ID 0
> Implementation ID 16
> Shadow count 0
> Page buffers 20799
> Next header page 0
> Database dialect 3
> Creation date Jan 18, 2004 19:37:37
> Attributes
>
> Variable header data:
> Sweep interval: 0
> *END*

<The statistics is almost totally uninformative without DDL for
tables!!!>

Please post the DDL for the Ledger table only, including the indexes.

Additionally, your query is very confusing, please explain:

- Why are you check for both the effective date and the entered date?

- Why are you also comparing the ID values using the <= operator?


Sean