Query via VBA

[Edgar Thoemmes]

Hi

This is a repost of a post i entered into the microsoft.queries forum but as
i think it needs to be done in VBA i will repost here.

The problem with this method is that the subform which displays the Book
Details is a continuous form as there could be many books on each invoice.

I was thinking along the lines of what you suggested but i thought i would
need to somehow loop through the recordset set like

for x = 1 to Number of Records in Recordset
for i = 1 to Quantity Field
append SQL here
next i
next x

So to summarise i have a the following table
tblTEMPBookDetails(InvoiceNumber, BookID, ISBN, Title,
Author, Quantity, UnitPrice)

With the following record
Inv4224, 554, 1855069906, Dictionery of 19c Philosphy, A Author, 5, £450

I would like to append 5 records to table tblCopies InvoiceNumber, BookID,
UnitPrice

I want to do this via VBA so I can also convert the currency of the unit
price as this might not always be in sterling - could anyone suggest anyways
of doing this?

--
Many Thanks

Edgar

----------------------------------------------------------------
e dot thoemmes at blueyonder dot co dot uk

******************************************************************
ORGINAL POST
******************************************************************