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

Welcome to another Quick Queries video brought to you by Access Learning Zone. I am your instructor, Richard Rost. Quick Queries videos are designed to let me answer as many of your questions as possible! In today's video...
TOPICS:
Spaces in field names
Autonumbers are not for you!
Sequential numbers
Which mic did you choose?
Open 32-bit database from 64-bit Access
Relationships
Invoicing
Association Database
Member Perk: Pre-Release Videos
Can grow/shrink in forms
ADDENDUM:
Cody also needs a space before the word WHERE.
BECOME A MEMBER:
TH-cam: / @599cd
or My Site: 599cd.com/THMe...
LEARN MORE:
599cd.com/QQ6
PREVIOUS QUICK QUERIES VIDEO:
QQ#5: 599cd.com/QQ5
LINKS
Access Beginner 1: 599cd.com/ACB1
AutoNumbers Are NOT For You: 599cd.com/AANFY
Sequential Numbers: 599cd.com/Counter
Tonor Mic: amzn.to/3Jlv0b4
Boom Stand: amzn.to/3kGPjp3
Import Objects: 599cd.com/Impo...
64-Bit Access: 599cd.com/64bit
Relationships: 599cd.com/Rela...
Invoicing: 599cd.com/Invo...
Association 1: 599cd.com/Assoc
Join Today: 599cd.com/THM
Can Grow, Shrink: 599cd.com/CanGrow
COURSES:
FREE Access Beginner Level 1: 599cd.com/Free1
$1 Access Level 2: 599cd.com/1Dollar
FREE TEMPLATE DOWNLOADS:
TechHelp Free Templates: 599cd.com/THFree
Blank Template: 599cd.com/Blank
Contact Management: 599cd.com/Cont...
Order Entry & Invoicing: 599cd.com/Invo...
More Access Templates: 599cd.com/Acce...
ADDITIONAL RESOURCES:
Donate to my Tip Jar: 599cd.com/TipJar
Get on my Mailing List: 599cd.com/YTML
Contact Me: 599cd.com/Contact
TechHelp: 599cd.com/Tech...
Consulting Help: 599cd.com/DevNet
Twitter: / learningaccess
en.wikipedia.o...
products.offic...
microsoft.com/...
KEYWORDS:
microsoft access, ms access, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #instruction, #learn, #lesson, #training, #database, quick queries, qq, Spaces in field names, Autonumbers are not for you, Sequential numbers, Which mic did you choose, Open 32-bit database from 64-bit Access, Relationships, Invoicing, Association Database, Member Perk Pre-Release Videos, Can grow/shrink in forms
QUESTIONS:
Please feel free to post your questions or comments below. Thanks.

[@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. :)

[@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.

[@gregoryjeffries8475]

Love these, thought you had given up on them.

[@599CD]

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

[@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.