Search results for query: *

Thanks for posting but ive already more or less got the imbetween date comamnds working. Perhaps I should explain it a bit more. in the query at the moment ther are 2 important fields 'date of transaction' and 'warranty due' at the moment in the field value for warrant due is 'warranty due...

Alright this is probably a bit of a novice question to ask but im having problems with it so im hoping someone else can help. What i need is to craete a query that looks at a date field in a table adds a year to it and will then display it if its within the search parameters. e.g. the first...

Thanks for the replies the equation now works 'sort of' atleast enough for me to play with. I may attempt to do it in a query as lespaul suggested as the system will need to be able to renew books. Ive got to try and design and make the rest of this system over the weekend and with my limited...

Hi all im new to both this forum and Access so if this should be posted in a different part of the forum please tell me and I will. I'm working on creating an electronic library system on access as part of a project and im trying to create an iff function which will look at the date when the...