Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2004
    Cary, NC

    Question Unanswered: Use different query for one field in a report

    I have a report (jobCost) that displays certain information by job number. As a convenience I want to display one other piece of semi-related information in the header for each job (YTD Cost). The YTD information comes from another table then the report source uses. I have a query that runs independently (qryYTDbyJob) which shows the YTD cost by job.

    What I want to do is put the YTD field in the header for every job in the jobCost report. I put a field in the header but I can't seem to get the data source to pull in from the YTD query for the appropriate job.

    How do I get a field in a report to pull from a different datasource than the report itself while still maintaining the job number sections?



  2. #2
    Join Date
    Apr 2004
    If that query is a simple sum query you could set the text box's control source to the DSUM function. This would allow you to build the sum for that job, as an alternative you could build the sum as a sub select in your original query then the field is already available to you when the report runs.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts