Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004
    Cambridge, Ontario

    Unanswered: Report using multiple queries

    Hi all,
    I am trying to create a report in the design view of access. The report is aimed at showing totals for different "categories" of our inventory table. In order to get the info together I made a query for each different category.
    The problem is that when I try to use the query info in the report (in the controlsource field) I get a #name? error. Any idea what the problem is? Thanks
    Phil J.
    Cherry Forest Veneers Ltd.

  2. #2
    Join Date
    Sep 2001
    Chicago, Illinois, USA
    Why are you using different queries ?

    Can't you just use a single query and group on the category differences ?

Posting Permissions

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