Case insensitive and date ranges

[663scott]

Hi,

Two questions.

Firstly how do I make a primary key case insensitive to allow username: John and john for example to be entered into it. My database is just a single table so would it matter if I define username as a primary key? I dont think it would.

Secondly, I would like to work out the difference between two date ranges. If i send out a request to a supplier for an item, and I fill in a date sent and date recieved field for each supplier. Could I work out the average amount of time in days it would take to recieve each particular item ?? What function would i need to use, and could it work this out using a date field ?

thank you


Scott
Funds and security management

[MMcCarthy]

Firstly how do I make a primary key case insensitive to allow username: John and john for example to be entered into it. My database is just a single table so would it matter if I define username as a primary key? I dont think it would.

Scott the primary key should be a number (autonumber) field for many reasons to do with indexing and sorting. Also in your case the text field will give rise to different case problems.

[missinglinq]

Access is, by default, case insensitive! JOHN = john = John = jOhN