gam3r

Im doing the Module 3 mock coursework for AS Level Computing and im stuck. I've made my database and made quite alot of validation rules using Visual basic and the code builder but what im stuck on is this. My database is actually a Tennis court booking database with relationships.

Here is what i need help with:

I have made a query to show all the bookings but now what i want it to do is show the bookings for the week starting Saturday(i know the week starts sunday but the specs say saturday). Ive got it to show all the bookings so far but i can't get it to show the bookings for this week starting on saturday.

've tried using now()+7, date()+7 Between "date()" and "date()+7"

Can anyone tell me what i have to do? I've googled it but all i found was a solution on experts exchange but you have to pay to see it

Hope you understand what im getting at.

Thanks for reading!

__________________
biggest NOOB ever :P

MBirchmeier

Chances are if this is for your coursework there's a good possibility it's somewhere in your notes/reading or was covered in lecture.

Additonally at expertsexchange you can see the answer if you scroll below all of their advertisements, or click around a bit, it's not intuitive, but it can be found without registering.

I don't have much information about access so I can't help you there, but hopefully the other site migth have what you're looking for or maybe someone else here can help.

-MBirchmeier

gam3r

Thanks for replying mate.

I assure you i don't have it in my notes because this is a project and teachers don't tell you set ways to do things/how to do things. Instead you gotta go find out yourself

Are you sure experts exchange is free? because it says i have to suscribe to view the solution!

__________________
biggest NOOB ever :P

MBirchmeier

Provide a link and I'll tell you how to get the answer... unless something's drastically changed in the last year or so it's free, it's just not intuitive.

-MBirchmeier

gam3r

https://secure.experts-exchange.com/...1652390#signup

Thanks again

__________________
biggest NOOB ever :P

MBirchmeier

You have to go back one page. If you've clicked the orange 'view solution' button you've gone too far. I assume this was the page you were on before clicking the view solution button:

http://www.experts-exchange.com/Data..._21652390.html

Simply scroll down to the bottom without clicking view solution and you can view the solution without signing up.

Like I said they're tricky.

-MBirchmeier

gam3r

Thank you again for replying and helping.

I've scrolled down but i don't see any solution..just shows more departments of the website

__________________
biggest NOOB ever :P

OpenLoop

maybe you should wait for the page to load

MBirchmeier

Clear your cookies and cache... I just noticed it worked when I clicked on it, it was there, I started my response, clicked again and it was gone, cleared my cookies and it came back.

They probablly have it set to let you see 5 or 10 pages at their site before blocking you.

Like I said they're tricky bastards.

-MBirchmeier

gam3r

Works now, thanks. wasn't working at all yesterday

__________________
biggest NOOB ever :P