Results 1 to 3 of 3
  1. #1
    Huddle is offline Competent Performer
    Windows XP Access 2010 64bit
    Join Date
    Jun 2010
    Posts
    318

    SQL Query turning field into an Expr


    When I drag a field down into by SQL Query and Run it the header Reads "Expr1001" and of course it doesn't bring up the data. Why is it doing this?

  2. #2
    JoeM is offline VIP
    Windows XP Access 2007
    Join Date
    Jun 2012
    Posts
    3,904
    Not quite sure I understand what you mean. Could you give us more info on exactly what you are doing?
    Note, I have seen if you add the same field multiple times to a query, it often gives the second one a title of something like what you are seeing.

  3. #3
    Huddle is offline Competent Performer
    Windows XP Access 2010 64bit
    Join Date
    Jun 2010
    Posts
    318
    That was it. I had the field in there multiple times. Thank you.

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

Similar Threads

  1. Turning a cell red
    By Sharong in forum Access
    Replies: 3
    Last Post: 09-28-2011, 01:51 PM
  2. Expr. to calculate 'Age' from Date field
    By JohnB47 in forum Queries
    Replies: 18
    Last Post: 08-17-2011, 04:10 AM
  3. Turning a Value into a positive
    By swagger18 in forum Programming
    Replies: 7
    Last Post: 01-25-2011, 09:42 AM
  4. Replies: 9
    Last Post: 01-21-2011, 03:57 PM
  5. Expr to Form and Table
    By OpsO in forum Access
    Replies: 3
    Last Post: 07-19-2010, 10:05 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