asked on

DataReport - DataEnvironment - SQL statement

Hi - I have VB6 includes DataReport. I use DataEnvironment (via Access) on my Datareport. Everything displaying fine so far. I have an Invoice file linked to Horse file (child). Then the Horse file linked to Ownership file (child), then finally an Owner file linked to my Ownership (all child commands). In my report at the bottom, depending on the Owner's Percent of the horse (percent in ownership file), an invoice amount is printed. The invoice subtotal is from the invoice and the percent is in the ownership file (as there may be more than one owner per horse). I need to get the amount a particular owner would have to pay on the report. (Invoice total * ownerpercent). I've looked through vb help but cannot understand the SQL child command thingy. I've found help here many times, but first time posting. Thank you.

ASKER CERTIFIED SOLUTION

23637269

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Colleen

ASKER

ty Roger. I found the solution after many days of looking through various solutions. What I needed to do was create a dummy sql that attached to my DataReport. Then I just filled my invoice form (datareport) with labels instead of textboxes. Then I generated my amounts in VB and passed them into my VB using the labels. What I need was to create what the owner pays from 2 of the 4 tables, but still need the tables linked (joined) for all information to be printed on the report.
My next lesson is to increase my point value when I post a question here, otherwise the experts don't want to waste time on a 250 point question. My first time posting, so I didn't know.
Ty for commenting Roger.