Results 1 to 2 of 2

Thread: Data Reports

  1. Apr 6th, 2001, 04:14 AM #1
    amccallum
    amccallum is offline

    Thread Starter
    New Member
    Join Date
    Apr 2001
    Location
    Glasgow Scotland
    Posts
    7
    Data Reports - I need to get data from more than one table for use in a report - Can anyone tell me how to do this - using vb 6 and Access 2000

    Thanks
    Reply With Quote Reply With Quote
  2. Apr 6th, 2001, 09:39 AM #2
    jon_rob
    jon_rob is offline
    New Member
    Join Date
    Apr 2001
    Location
    UK
    Posts
    8
    You can build an SQL statement in VB (using Access syntax) and append it to the Access 2000 QueryDef or Hard code a Query in your Access 2000 back end. The query can then be used like a recordset.
    There are other ways be these are the simplest.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width