Search results

Thats my issue , Access 'guesses' , suppose the month should have been 12 and not 25 but somehow got corrupted by the code , instead of failing it 'guesses' and updates the wrong rows and now your data is corrupted and the bug that corrupted your code has gone unnoticed.

Create another table that groups the variables you want together and link to it , eg. New Table : Daycodes columns : Days, Code Rows ; Days Code ----- ------ 1,2,3,4 FOUR 1.2.3.4 FOUR ALL FOUR Your query should link to this on the column Days and the where clause...

I'm new to Ms Access (I'm a unix DBA for 20+ years) and have been developing a small app for a friend. Now i know that in Access you must use the US date format in queries, but I came accross this when my app was causing me grief ; Table : timesheet Columns : tsName,tsCode,tsDate,tsHours...