Access

Resolved · Low Priority · Version 2000

Access

Anna has attended:
Access Intermediate course

by - delegate Anna [1 post] (2008 Jul 29 Tue, 16:28) Reply

I am using Access 2000. I have set parameter queries requesting date ranges on a couple of my queries, but often it asks for both start and end date more than once. It doesn't look like there is any duplication in design view. Any ideas what could be causing this please?

Version	Date	Location	Places available	Book	Next place rate:
Access VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2009 Jan 8 Thu + 9 Fri	Southwark	4	book now	£475	£485
2003	2009 Feb 5 Thu + 6 Fri	Southwark	6	book now	£450	£485
2003	2009 Mar 5 Thu + 6 Fri	Southwark	7	book now	£345	£399
2003	2009 Apr 8 Wed + 9 Thu	Southwark	8	book now	£275	£399
2003	2009 May 7 Thu + 8 Fri	Southwark	8	book now	£275	£399
2003	2009 Jun 4 Thu + 5 Fri	Southwark	8	book now	£275	£399
Full Schedule: See all 11 Access VBA course dates. Bookings currently available until 5th November 2009.

RE: Access

by - trainer Carlos gold contributer [479 posts] (2008 Aug 1 Fri, 16:32) Reply

Hi Anna

Sorry for the delay.

If you could send me a screen shot of the query’s design view to the address below it may help me to understand it better.

Info AT microsofttraining.net

You also say this happens often. Does that mean the sometimes the query runs as normal?

If so, it may turn out to be a technical problem with Access 2000 rather than a problem with the Query design.

If we need more info we’ll come back to you and let you know if this is something we can cover as part of the forum.

Regards

Carlos