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?
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?