Richard,

when you run the query, there is always a default in the last record.
1.Is that default always there?
2.Is ithe defalut (say state) NY because that's the first state in the record?

Thanks,

Patrick

---

Reply from Richard Rost:

1. Yep. If you've set a default value in the table it will always show there.
2. No. That will ONLY show up there if you've set it as the DEFAULT VALUE property for the field in the table design. The value isn't ACTUALLY there until you start entering other data in the record.