Results 1 to 3 of 3
  1. #1
    alobi is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Jan 2013
    Posts
    7

    Could not see a query result


    HI
    I am running the following query for a test run but when I provide the peramenter and click ok, nothing appears except an empty dataset. What am I doing wrong and how I do fix the problem

    Thanks
    PARAMETERS LName Text ( 25 );
    SELECT EmployeeTbl.EmpID, EmployeeTbl.LastName, EmployeeTbl.FirstName, EmployeeTbl.MiddleName, EmployeeTbl.DateEmployed, EmployeeTbl.EmployeeStatue, EmployeeTbl.Phone
    FROM EmployeeTbl
    WHERE (("Where LastName" Like "LName"));

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,929
    I've never used PARAMETER. Review http://fontstuff.com/access/acctut01.htm

    Maybe:

    WHERE (([LastName]= [LName]));

    Where does LName get populated? Is this supposed to be a parameter input popup?

    LIKE operator is only useful with wildcard.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    alobi is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Jan 2013
    Posts
    7
    LName gets populated from a popup. I am using Access DB tool to construct this query and that is what I came up with. I have decieded to use the '=' operator it will serve the same purpose
    thanks

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

Similar Threads

  1. Replies: 8
    Last Post: 05-16-2012, 09:30 AM
  2. Query Result Export
    By worldwidewall in forum Access
    Replies: 6
    Last Post: 02-08-2012, 09:05 PM
  3. VB ADO Query Result Set
    By Bedsingar in forum Access
    Replies: 5
    Last Post: 09-05-2011, 10:45 AM
  4. How do I determine a SQL query result?
    By Trainman in forum Database Design
    Replies: 1
    Last Post: 10-15-2009, 04:49 AM
  5. Result of Count Query not known elsewhere
    By Carole in forum Access
    Replies: 1
    Last Post: 09-07-2008, 09:39 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