Microsoft Access TechHelp Quick Queries #6 - Space in Field Name, AutoNumbers, Can Grow/Shrink, More

[@abdullahfelemban953]

Thank you for your efforts.
I watch your videos for 5 hours per a day for almost a month.
I learned a lot of skills.
Thank again.

[@599CD]

Swweeeeetttt

[@jimyeske8498]

Hey Richard,
Thanks again for your assistance!
I’ve been doing a retirement hobby for the past 3 years (each year busier than the last) and have decided in my spare time to convert my spreadsheets to an Access db. I think I’m on my third version now! 😊. After watching your videos, each new version has been much better than the last.
I’ll keep watching, if you keep making them!

[@599CD]

Roger that. :)

[@gregoryjeffries8475]

Love these, thought you had given up on them.

[@599CD]

I did for a while... but they're back! :)

[@getinetmolla8]

Good afternoon Mr. Richard,I'm not member but curious attendant of your amazing releases. Please cover this: when access table is exported to excel , drop down columns go as number format(ID) not attributes, could it be solved? Thanks.

[@ssdusd]

Thanks
Question
Let's say today's date is February 8th. How can I extract the 8th of February that falls between Sunday, 5th of February to Thursday, 9th of February? Note that our week starts from Sunday to Thursday

[@jldsystemsltd.4657]

Another issue with Cody's SQL is the lack of space between the field name and his "Where..." clause.

[@599CD]

Yup. I think I mentioned that somewhere... Good catch tho.