Search results

Hello! A quick question about dates... In a rate_date field, I store the value '1/8/2004' as in 1st August 2004 (well... at least that's what I thought it was storing). When I write a simple select query like... select pay_rate, rate_date from PayRates where pay_rate = 'marking' and rate_date...

Hi! I'm having a 'type mismatch' error in the following SQL statement in my VB code... stSQL = "Select [AmountPerHour] from PayRates where [Pay_Rate_ID] = 'marking' And [Rate_Date] = Me![Rate_Date] " After debugging I can see that Rate_Date holds the value 9/09/2004 as does Me![Rate_Date]...

Hello...help!! I have a table 'PayRate' which has three columns - payrate, date_changed and amount - payrate and date_changed are both primary keys.. In another table which keeps a record of pay called 'paydetails'.. I also have the keys payrate and date_changed... payrate here is a lookup on...