Replies

The problem I’ve got with the query is how to add a text field. It works fine when I add a additional field that is a number but I can’t seem to get it to work for text. I get one of two errors depending on whether the field contains one (Too few parameters. Expected 1) or more than one word(Syntax error. Missing Operator in query expression ‘ firstword secondword’)

Thanks, I’ve got the attachment.
Where it says ‘enter code to log printing’ do you mean the simple code from your first reply.
Also, I’m unable to figure out how to add another field (say “ContractNo”) to the append query. I’m pretty new to all this and a bit out of my depth.
Lastly, and I think this is way, way out of my depth, would it be possible to extract the user id (either the database user – although no one is logging onto the database yet – or the windows user) to log who did the printing?

Thanks, but where do I find the attachments you mention?