Search results for query: *

Could you give a bit more detail please chris - coding isn't my forte unfortunately :-( Thanks

Hi Alex, Thanks for the reply. That's something I've thought about but i'd like to avoid hard coding the SQL within the VBA if at all possible. Many of the people i work with are scared of getting their hands dirty with vba so i'm looking for another solution if there is one?! Thanks, Paul

I have approximatley 10 select queries set up which are run on a monthly basis. The common factor between these queries is that they all use the same parameters (start date and end date) What i would like to do is run all 10 of these queries and only have to enter the parameters once. I have...

No worries, you brought to light a good few issues and got me looking at cursors! Oh how exciting are cursors!! Ha ha. Thnaks again

Thanks guys... I cracked it - used a stored procedure and its working great!! So far so good!! Paul

Thanks guys... You've given me food for thought!! I am creating a recruitment database and need to create some kind of allocation function. I would like something like this: StaffID StartDate EndDate 1 12/12/2003 14/12/2003 2 03/02/2002 15/08/2003 2...

This might sound a bit of an odd question to all of you experts but i have the requirement to join 2 views. View 1: StaffID StartDate 1 12/12/2003 2 03/02/2002 2 20/04/2004 2 etc 3 View 2: StaffID EndDate 1 14/12/2003 2...