Azure Jane Lunatic (Azz) 🌺 (![[personal profile]](https://www.dreamwidth.org/img/silk/identity/user.png)
azurelunatic) wrote2007-02-15 02:54 pm
azurelunatic) wrote2007-02-15 02:54 pm
Afternoon!
12:49 PM 2/15/2007
Holy mother of swiss cheese. The problem that I'd been trying to track down the other week before getting the stats for January out? I'd named January's end date 1/31/2007 in the Jobs table, and 01/31/2007 in all the other tables. *facepalm* That is not so good for my ego.
1:36 PM 2/15/2007
Have called the car place & they'll be retrieving me. Hooray for cooperative car places.
2:54 PM 2/15/2007
Cleaned out the table that might have been causing another problem. 3/4 of the append queries for the month are done; it's that 4th one that's causing all the trouble.
Holy mother of swiss cheese. The problem that I'd been trying to track down the other week before getting the stats for January out? I'd named January's end date 1/31/2007 in the Jobs table, and 01/31/2007 in all the other tables. *facepalm* That is not so good for my ego.
1:36 PM 2/15/2007
Have called the car place & they'll be retrieving me. Hooray for cooperative car places.
2:54 PM 2/15/2007
Cleaned out the table that might have been causing another problem. 3/4 of the append queries for the month are done; it's that 4th one that's causing all the trouble.
no subject
Incidentally, I think most spreadsheets have a "date" cell format or data type for cells, which may help avoid similar problems in the future. (Not guaranteed, because it depends on the details of what the exact problem was, and how the spreadsheet deals internally with things you told it are dates. Also, it may make things worse by hiding the specific problem you mentioned, if dates entered as 1/31/2007 and 01/31/2007 were displayed the same but stored differently.)
no subject