MS Access Queries Hoping someone may be able to help out. I've foolishly taken on a project at college which I'm hoping to incorporate a database into. Since the last time I fiddled around with Access was about 6 yrs ago, I'm struggling eeeeeeeeeeeever so slightly Right, basically I'm in the process of creating a database to contain information for a tendering system which records the tender details, such as date received, proposed return date, actual return date and value of the tender submission. What I want to do, is run a query on a weekly basis run a query which picks up the submissions that are due in that particular week. So for example, the query would be run on a Monday morning, and it would pick up every tender that is due in between that particular Monday and the following Friday. I'm probably making it sound a lot more complicated than it is, but any help would be greatly appreciated. I may have a few more queries which hopefully a few of you may be able to help with, but I think I'll stick with this one for starters. Thanks
Just run the query wizard mate.. You can set that sort of thing up from there. Alternatively.. u could use SQL.. SELECT Recieved, Return, Act return, Value FROM Tendering WHERE Day="Friday" Or SELECT * FROM Tendering WHERE Day="Friday" SELECT identifies the fields you wish to display FROM identifies which table you want to take the field information from WHERE specifies the value you wish to sort the information by.. in this case the field "Day" must be equal to "Friday" You could use an OR statement as well to grab multiple days.
Not sure if I'm following to be honest You'll have to bear with me as its been a while since I've used Access to any sort of level. Basically, the table I've created just has the dates set up as dd/mm/yy so say I was running the query on Monday gone, I'd need it to cover 27/11/06, 28/11/06, 29/11/06, 30/11/06 and 01/12/06 but obviously I'd need to run the same query on a weekly basis. I've been able to get the query to select anything to be returned on the day the query is ran (=date()), but unsure as to how to get it to cover a working week. Looks like I've shagged the database as now it won't open! Effing brilliant!
