Prev: SQL totalling items report
Next: Duplicate fields in Access Database
From: ghetto_banjo on 16 Mar 2010 10:55
Oops that TOP 2 should read TOP 20
From: pat67 on 16 Mar 2010 11:13
On Mar 16, 10:55 am, ghetto_banjo <adam.v...(a)gmail.com> wrote:
> Oops that TOP 2 should read TOP 20

thanks. let me try it
From: pat67 on 16 Mar 2010 11:17
On Mar 16, 10:55 am, ghetto_banjo <adam.v...(a)gmail.com> wrote:
> Oops that TOP 2 should read TOP 20

That seems to be working. then i can just count the won and lost for
records.

Thanks
From: ghetto_banjo on 16 Mar 2010 11:50
No problem, glad it worked. those subqueries get confusing,
especially when referencing the same table as main query.
First  |  Prev  | 
Pages: 1 2
Prev: SQL totalling items report
Next: Duplicate fields in Access Database