Results 1 to 2 of 2
  1. #1
    ruitarouco is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Apr 2015
    Posts
    1

    Getting all records in a query

    Hi, I did a query where i putit a caracter (?) in criterium. this serves to get the records correspondent to the criterium i want. but i also want to get all results in this query. what is the caracter i have to write to have all records wen the query asks for the criterium ?


    Thank you

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,870
    Watch some youtube videos on tables and queries.
    Here is a guide to Access Basics

    If English is not your native language, use Google translate to convert the question/post in your native language to English.

    Readers only know what you tell us. So for any question it is helpful if you describe the problem/opportunity in plain English; tell us WHAT you are trying to do; include your query SQL or code if applicable; if you are having issues with a query, then show us your table designs and some sample data.

    Welcome to the forum and good luck with your project.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 4
    Last Post: 03-29-2014, 01:29 AM
  2. Replies: 1
    Last Post: 01-24-2013, 05:50 PM
  3. Replies: 4
    Last Post: 08-02-2012, 10:59 AM
  4. query won't display records with no related records
    By James Brazill in forum Queries
    Replies: 1
    Last Post: 06-28-2011, 02:10 AM
  5. Date function to query records and Sum records
    By sullynivek in forum Queries
    Replies: 0
    Last Post: 04-05-2011, 08:37 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
  •  
Other Forums: Microsoft Office Forums