Recent content by rjtetley

Hello, Thanks very much for this. I am seeking to create a query, from an 'Allmembers' table, from which I can select a number of random records, then to copy these records into another query, from which I can create a report formatted to create a set of labels. I have created a Report for...

Is there a way to select non-contiguous records in an Access table or query please? I'm sure this must be a topic already covered but I haven't found it. Richard Tetley :confused:

Thanks for this. I will have a go.Another helpful member reminds me that I could have a separate table for Member Types to avoid the need for code. I have enough to get me going again now.

I am just getting the hang of this website. Thanks for this response. I take your point

Access 2003 syntax Can anyone help with the following problem concerning Operator syntax please. Access Help and Alison Balti's Mastering Access 2003 do not enlighten. Problem I have a field in a query for MemberType in a membership database. Member Types are designated in a...