Some VB code

M

mtrimpin24

hi, i'm having trouble creating some vb code to do the following, since i'm
not that familiar with sql. how would i do the following, in visual basic
code to run from a macro, or a button press?

must do following, during the process of importing to the table.
put 10% of recordset size in an integer (concatenate as necessary)
exclude all records that contain the text "mile" "mlg" or any other
abbreviation for "mileage" in the .[report name] field
Tableappend gets all records that: for orgs 010, 528, 113, 185 where
..postedamount > $1500.00
tableappend gets all records where .postedamount> $3500.00
tableappend further should receive 10% of the remaining records, following
the following formula:
every 10th record should be included in tableappend, up to 10% of the total
number of records, roundedd down.

could anyone provide the vb code for that, or its macro/query equivalent?
thank you!



a set of append queries?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top