I have a problem I'm looking to solve, and not sure about the best way to do it.
I have a booking system where the user will be booking in up to 10 lessons per customer each week. I'm trying to come up with a method of making this easy in one step. rather than making the user manually input...
I'm new to access and databases and I'm trying to design a database where the user will be able to book a customer in for a lesson.
A lesson will be either morning or afternoon, monday to friday.
I originally had a M:N relationship between tblCustomer and tblLesson (as many customers could...
Is it possible in a query to convert the date to the day as text. I've used Day: Weekday([dteSessionDate]) to get the value 1-7 but ideally I would like it to display Sunday - Saturday
Thanks
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.