Results 1 to 5 of 5
  1. #1
    smarty84handsome is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Jan 2012
    Posts
    67

    Lightbulb Query Parameter

    I have created a query based on the table which gets updated every time i enter new data in forms. I am having difficulty when i create specific parameter and try to run the query i don't see the anticipated results. Either query will not display specific parameter rather display every contents of table or either it won't display anything. How do i correct this problem i would appreciate experts help

  2. #2
    smarty84handsome is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Jan 2012
    Posts
    67
    To be more precise my query fields are,
    Employee ID
    Entry Date
    Amount

    Now every time i create a parameter on employee id such as [enter employee number] and then try to run the query nothings displays

  3. #3
    ssanfu is offline Master of Nothing
    Windows 2K Access 2000
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    Quote Originally Posted by smarty84handsome View Post
    To be more precise my query fields are,
    Employee ID
    Entry Date
    Amount

    Now every time i create a parameter on employee id such as [enter employee number] and then try to run the query nothings displays
    Please post the SQL of the query.

  4. #4
    smarty84handsome is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Jan 2012
    Posts
    67
    SELECT [Discrepancy Table].[TSSR Date], [Discrepancy Table].[Entry Date], [Discrepancy Table].Amount, [Discrepancy Table].[Over/Short], [Discrepancy Table].Explaination, [Discrepancy Table].Type, [Discrepancy Table].Status, [Discrepancy Table].[Auditor Comments]
    FROM [Discrepancy Table]
    WHERE ((([Discrepancy Table].[Emp ID])=[Enter Employee Number]));

  5. #5
    smarty84handsome is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Jan 2012
    Posts
    67
    and if i remove parameter then it looks like this
    SELECT [Discrepancy Table].[TSSR Date], [Discrepancy Table].[Entry Date], [Discrepancy Table].Amount, [Discrepancy Table].[Over/Short], [Discrepancy Table].Explaination, [Discrepancy Table].Type, [Discrepancy Table].Status, [Discrepancy Table].[Auditor Comments], [Discrepancy Table].[Emp ID]
    FROM [Discrepancy Table];

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

Similar Threads

  1. How to run parameter query from VBA
    By John Southern in forum Programming
    Replies: 10
    Last Post: 02-07-2014, 02:24 PM
  2. Replies: 13
    Last Post: 01-10-2012, 09:56 AM
  3. Parameter Query....
    By Casper2012 in forum Queries
    Replies: 5
    Last Post: 08-16-2011, 11:06 AM
  4. Parameter Query?
    By luckysarea in forum Queries
    Replies: 3
    Last Post: 04-22-2011, 12:57 PM
  5. Parameter Query help...
    By daggy in forum Queries
    Replies: 1
    Last Post: 05-11-2010, 01:10 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