Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.databases.ms-access > #11161
| From | "Phil" <phil@stantonfamily.co.uk> |
|---|---|
| Newsgroups | comp.databases.ms-access |
| Subject | Re: Problem with query |
| Date | 2015-10-04 08:45 +0100 |
| Organization | Aioe.org NNTP Server |
| Message-ID | <muqle0$3fq$1@speranza.aioe.org> (permalink) |
| References | <muodnr$li4$1@speranza.aioe.org> <560fc911$0$23829$e4fe514c@news.xs4all.nl> <muopod$hal$1@speranza.aioe.org> <560ff696$0$23778$e4fe514c@news.xs4all.nl> |
On 03/10/2015 16:39:12, Luuk wrote: > On 03-10-15 16:46, Phil wrote: >> On 03/10/2015 13:25:06, Luuk wrote: >> >> Thanks >> The first query (Query3) runs very quickly, > > Bt you said: >> I have created 2 queries that give the correct results, but they take ages to >> run. > > > 'they', so BOTH queries take ages to run! > > and now you are saying that this query run quickly ? > >> >> Thanks >> >> Phil >> > > > end of problem.... > Obviously a misunderstanding. The first query Query3 is pretty well instantaneous well under a second. The second query takes about 90 seconds to run and I have a pretty fast computer. Phil
Back to comp.databases.ms-access | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread
Problem with query "Phil" <phil@stantonfamily.co.uk> - 2015-10-03 12:21 +0100
Re: Problem with query Luuk <luuk@invalid.lan> - 2015-10-03 14:25 +0200
Re: Problem with query "Phil" <phil@stantonfamily.co.uk> - 2015-10-03 15:46 +0100
Re: Problem with query Luuk <luuk@invalid.lan> - 2015-10-03 17:39 +0200
Re: Problem with query "Phil" <phil@stantonfamily.co.uk> - 2015-10-04 08:45 +0100
Re: Problem with query Luuk <luuk@invalid.lan> - 2015-10-04 15:38 +0200
Re: Problem with query "Phil" <phil@stantonfamily.co.uk> - 2015-10-04 22:10 +0100
Re: Problem with query Mike P <mikewpayne@tiscali.co.uk> - 2015-10-07 15:46 -0700
Re: Problem with query "Phil" <phil@stantonfamily.co.uk> - 2015-10-08 09:39 +0100
Re: Problem with query Mike P <mikewpayne@tiscali.co.uk> - 2015-10-16 14:50 -0700
Closed: Problem with query "Phil" <phil@stantonfamily.co.uk> - 2015-10-17 18:24 +0100
csiph-web