Bob, Create another table (tbl_Numbers) with a single field intNumbers containing values from 0 to 9. Create a query (qry_Numbers) from this that looks like: SELECT Tens.intNumbers * 10 + Ones.intNumbers as intNumbers FROM tbl_Numbers Tens, tbl_Numbers Ones This query will now give you the numbers from 0 to 99. Your new query will look like: INSERT INTO tbl_Transactions (RateDate
"Retief" <nospam@invalid.invalid> wrote In your case, "science" traffics only in lies...such as the ones you persist in posting. Lies like this one? Tundra Disappearing At Rapid RateDate - March 7, 2007 ------------------------------------- University of Alberta The boundary, or treeline, between forest and tundra ecosystems is a prominent landscape feature in both Arctic and mountain
On Mar 21, 8:43 am, MikeSoja <mso...@newsguy.com> wrote: On Tue, 20 Mar 2007 22:11:07 -0800, "Vendicar Decarian" <BushIsATrai...@hotmail.com> posted: <last_p...@rogers.com> quacked.... But the main reason is "tectonic activity" deep under the sea. So much for stupidity. Meanwhile.... Tundra Disappearing At Rapid RateDate - March 7, 2007 ---------------------
On Mar 21, 8:43 am, MikeSoja <mso...@newsguy.com> wrote: On Tue, 20 Mar 2007 22:11:07 -0800, "Vendicar Decarian" <BushIsATrai...@hotmail.com> posted: <last_p...@rogers.com> quacked.... But the main reason is "tectonic activity" deep under the sea. So much for stupidity. Meanwhile.... Tundra Disappearing At Rapid RateDate - March 7, 2007 ---------------------