How Do I Create One invoice From a Query listing several ID's

[ChrisGardner]

I am trying to build a database in which a user inputs the values to properly calculate an invoice (Invoice type 1, 2, 3, or 4). I currently have the queries setup to properly calulate the totals. Put, I am having a problem in understanding how I get Access select which Query to read and then create a seperate report for each ID listed in the query.

If it comes to VB coding, I am clueless!!

Can anyone help, I have been searching Access help and books for the past 2 days??

 

[batteam]

Could you not have all the invoices generated by only one query but have the form send a parameter over to it, this parameter depending upon which invoice the user picks, that has the query calculate the right totals for that invoice?

If this is not possible, you might try a Select Case statement. Something like:

cmdCalculateInvoice_Click()

Select Case [thechosentypeofinvoice]
Case [type1]
DoCmd.OpenQuery "querynamethatcalctype1
Case [type2]
DoCmd.OpenQuery "querynamethatcalctype2
Case [type3]
DoCmd.OpenQuery "querynamethatcalctype3
Case [type4]
DoCmd.OpenQuery "querynamethatcalctype4
End Select

I know you said you don't know VB coding, but the Access 'Help' files can expalin this simple 'Select Case' command very easily. Try it, practice with a few made up examples on a practice form and see how easy it is. Hope this helps. Good luck.