I have a table with our store numbers vendor numbers as data for rows and beer brands as the headers. I also have a drop down list where I can select...
The strongest argument for having small lookup tables is this:
With an ongoing database, what if you want to change an existing salutation from, say...
(Having a separate primary key for a tiny table seems like a really odd thing to do... If it's only a handful of values, why not just store the real...
No you are not wrong, Access SQL is not case sensitive. T-SQL can be if you use the right syntax (Collate I seem to recall) but otherwise is also not...
I'm not sure what you mean or what the mystery is. Access sql is not case sensitive, so your query doesn't care if the field contains L or l. If you...