Re: Help please:-Passing parameters to a query from a module
From: John Vinson (jvinson_at_STOP_SPAM.WysardOfInfo.com)
Date: 02/01/04
- Next message: anonymous_at_discussions.microsoft.com: "Re: query that runs two variables"
- Previous message: J. Kelly: "Separating a Mailing List"
- In reply to: Keith Stein: "Help please:-Passing parameters to a query from a module"
- Messages sorted by: [ date ] [ thread ]
Date: Sat, 31 Jan 2004 19:01:14 -0700
On Sun, 1 Feb 2004 00:24:48 -0000, "Keith Stein"
<ks012a2355@blueyonder.co.uk> wrote:
>Hi,
>
>I don't know any VBA but need to pass a range of dates to an append query.
>
>The query has a parameter "matchdate" and i need to run the append query
>each time for a speified date.
>
>All i want to do is something like:
>
>matchdate = #17/1/04#
>run append query
>matchdate=matchdate +1
>
>Loop until matchdate = #25/12/04#
>
>Can someone please give me a simple bit of code!
No code and no loop is needed.
Instead, create a small table with one date/time field; fill it with
all the dates in the desired range (you can do this quickly in Excel).
Include this table in your Append query with no join line, so that the
date is included on every row.
NOTE: Date literals in Access MUST be in either mm/dd/yy or an
unambiguous format (such as 17-Jan-2004). Day/month/year dates *WILL*
be misinterpreted.
John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public
- Next message: anonymous_at_discussions.microsoft.com: "Re: query that runs two variables"
- Previous message: J. Kelly: "Separating a Mailing List"
- In reply to: Keith Stein: "Help please:-Passing parameters to a query from a module"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
