Search results

That code worked brilliantly thanks mate, and thanks to everyone else, i'm sure i'll be on here again soon! :)

Just put the code in and it does exactly what i wanted it to do, thanks everyone. I'm sure i'll be back soon! :)

Thanks mate, at the cost of £10 i will get it myself! I'm going to order that book in a moment and see where it get's me. My problem is i only get to play around with Access at work because i've only got a Mac indoors and i can't run it on there. I've put you're bit of code in, i'll have to...

I've tried putting it in how it makes sense to me but i get an "operator missing" error. I put it in like this: SELECT Complaints.[Date of investigation] FROM Complaints WHERE Date() - Date of investigation > 14 AND Action completed = False

Thanks DreamGenius, didn't even know this view existed. the code that comes up when i do that is this: SELECT Complaints.[Date of investigation] FROM Complaints WHERE ((([Complaints].[Date()-"Date of investigation"])>14) AND (([Complaints].["Action completed?"])=False)); I can see where the...

I understand where you're all coming from, this is a learning exercise for me and my company doesn't require this as an integral work system. It was an idea brought up at a meeting and i thought i may be able to extend my knowledge of Access by trying to get something in place. I know i have...

Sorry to be a pain but as i said i only know the very basics. I've never used the queries before but i've attached a pic of how i interpreted your responses. As you are probably going to guess it didn't work :) Could you point me in the direction on how to properly set it up? Thanks you all...

Hi everyone, been looking around the threads here for a while now trying to find an answer to my question but i've had no luck. I'm not an Access guru or anything but i can build simple databases, not got a clue with VB at all. I've been asked to produce a database at work for customer...