Append with user input

[Rob P]

Hi

I am trying to create an append query which the when run the user can enter
some text at the point before appending

Eg this is part of the query which works

SELECT DISTINCT Date() AS TodaysDate, "Letter re appointment " AS
ActionNotes, "Post" AS ContactType
FROM tblCompanyDetails INNER JOIN .......

but I want to have the user enter any text in place of "Letter re
appontment" if I use [] in the query that field remains blank in the
appended table

Many thanks

 

[MGFoster]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

You may wish to try the PARAMETERS clause, like this:

PARAMETERS [Enter notes] TEXT;
SELECT DISTINCT Date() AS TodaysDate, [Enter notes] AS ActionNotes,
"Post" AS ContactType
FROM tblCompanyDetails INNER JOIN .......

The value entered in the parameter [Enter notes] should show up as the
2nd column in the result set.

MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQCx5fIechKqOuFEgEQJy9gCfR8M0Q159jNKLoejJjH4hxa1iFnAAnisc
DB+3AOlWD7By236Nr5TPDkTU
=XXam
-----END PGP SIGNATURE-----