Results 1 to 4 of 4
  1. #1
    DBS1 is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Nov 2020
    Posts
    47

    Retrieve Data from Query other than Recordsource


    I have a report that I would like to pull data from a field that is in a separate query than the recordsource query. The field has no relation to the data in the recordsource, so I can't establish a relationship between the recordsource query and the query this field is in, but would like to display this data on the report. Is this possible?

  2. #2
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    4,942
    Not recommended in queries generally, but that is when you can join the data, but you could try a DlLookup() ?
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

  3. #3
    Bob Fitz's Avatar
    Bob Fitz is offline Access Developer
    Windows 10 Access 2016
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    3,544
    I can't really understand what data you might need but perhaps you could use DLookup()

    Can you give us more detail
    If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
    Bob Fitzpatrick

  4. #4
    DBS1 is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Nov 2020
    Posts
    47
    Thanks friends from the UK Welshgasman and Bob. I thought I had used something in the past and this is it. I appreciate the quick and helpful response.

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

Similar Threads

  1. Replies: 3
    Last Post: 05-24-2021, 02:01 AM
  2. Recordsource for data entry form
    By steve7800 in forum Forms
    Replies: 1
    Last Post: 09-20-2020, 12:36 AM
  3. Retrieve a data by using query
    By trident in forum Queries
    Replies: 7
    Last Post: 02-03-2016, 11:33 PM
  4. using SQL in VBA to retrieve data
    By sovereign in forum Access
    Replies: 8
    Last Post: 08-25-2015, 10:17 AM
  5. Replies: 1
    Last Post: 03-17-2014, 12:26 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