Results 1 to 2 of 2
  1. 03-19-2018, 02:19 PM #1
    snowboarder234's Avatar
    snowboarder234
    snowboarder234 is offline Competent Performer
    Windows XP Access 2010 32bit
    Join Date
    Sep 2011
    Posts
    243

    How to construct a query that returns all books that have more than one author?

    Hopefully the results would also display the author's names.
    Reply With Quote Reply With Quote
  2. 03-19-2018, 02:28 PM #2
    isladogs's Avatar
    isladogs
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,974
    Assuming there is only one field used when there are more than one author, you could try searching for authors where the field includes commas, 'and' or '&'
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. Query Construct
    By zburns in forum Queries
    Replies: 2
    Last Post: 05-18-2015, 10:21 AM
  2. Overcoming another author's failure to normalize.
    By ch5150 in forum Access
    Replies: 19
    Last Post: 11-06-2014, 07:31 PM
  3. How to construct a BuildFilter
    By DBDave in forum Programming
    Replies: 5
    Last Post: 10-28-2014, 05:44 PM
  4. How to construct query to match field content in one table to field name in another
    By ekierce in forum Queries
    Replies: 5
    Last Post: 04-23-2013, 01:42 PM
  5. Author of Database
    By tmcrouse in forum Access
    Replies: 5
    Last Post: 09-23-2011, 07:26 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Other Forums: Microsoft Office Forums