Access

[ed moreno]

I have a student intervention database and I want to add
a newsletter intervention for all the students without
having to type this intervention for each indvidual
student.

 

[Kevin @ 3NF]

Sorry, but I can't find your question in what you wrote...what part do you
need help with?

 

[John Vinson]

I have a student intervention database and I want to add
a newsletter intervention for all the students without
having to type this intervention for each indvidual
student.

It *sounds* like you want an Append query, appending all StudentID's
and a literal text "Newsletter" to the Interventions table; just base
the query on the Student table.

But... you're presuming that the volunteers here know what an
"intervention" is, and making us guess at the possible structure of
your tables. For me at least, telepathy is rather spotty and not
altogether reliable!