Results 1 to 3 of 3
  1. #1
    Panzer336 is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jan 2013
    Posts
    1

    Getting a query to display the correct information

    I am a new user to access having had very little exposure to it before and am looking for some help. I have a small db that i created to hold mutile projects stock that i look after. I have started the query and so far it is ok. in the Criteria field have enster [Project Name] this as you all know prompts me with a dialogue box asking for the projects, however problem is when i enter the project name is just displays a blank table and none of the projects are displated.



    Any guidance would be helpfull, Tahnks Sandy

  2. #2
    alansidman's Avatar
    alansidman is offline VIP
    Windows 7 32bit Access 2010 32bit
    Join Date
    Apr 2010
    Location
    Steamboat Springs
    Posts
    2,506
    Is your project name spelled correctly and matches exactly as it is in the db. No preceding or trailing spaces?

  3. #3
    A S MANN is offline Advanced System Analyst
    Windows XP Access 2007
    Join Date
    Oct 2010
    Location
    India
    Posts
    160
    From table contain [Project Name] field copy the value of data in [Project Name] field and paste the value in Query when parameter asked
    That will solve issue.
    A S MANN

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

Similar Threads

  1. Display Query Information on a form
    By srmezick in forum Forms
    Replies: 2
    Last Post: 12-15-2011, 09:24 AM
  2. Replies: 9
    Last Post: 06-26-2011, 09:14 PM
  3. Replies: 1
    Last Post: 03-24-2011, 07:09 AM
  4. Changing information display method in forms
    By mrbaggins in forum Forms
    Replies: 5
    Last Post: 10-21-2010, 06:00 AM
  5. Need help with database to display vehicle information
    By jlmnjem in forum Database Design
    Replies: 1
    Last Post: 07-25-2006, 08:48 PM

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