Its backwards. The formula should be:
Column_Name: Int( [Value_to_round] / 1000 + .5 ) * 1000
CJD
Last Activity: Oct 12 '07, 06:38 PM
Joined: Jul 23 '07
Location:
-
Can anyone help me with this.Leave a comment:
-
VBA/ADO recordset problem from Access query
Hi,
I have a set of queries in access that I would like to import into excel. My problem is that there are no records are returned when the code is run, but I do get field names. This same code works if the query results are placed in a table, but to create tables for every query I need to get data from would be too much like work. Here is the code I’m using.
...Code:sSQL = "SELECT * FROM `Steady Customer for Chi_3-5bulk8`;"
No activity results to display
Leave a comment: