Search results

That fixed it. Thanks so much!

Arrrggh - Sorry guys I thought this was solved but I didn't test it properly. The one for First Month that boblarson posted works fine. But with the other two I keep getting the message: 'The expression you entered contains invalid syntax - You may have entered an opeand without an operator.'...

Boblarson, Thank you so much! You've made my day with your help! Thanks to everybody else aswell :D.

Thanks boblarson! However, unfortunately now I'm getting this message. 'Data type mismatch in criteria expression.' Any ideas?

Hi - just tried this and I'm getting an error message "The expression you entered contains invalid syntax." Any help on this?

edit - Cheers for your help!

I'm doing a database that records jobs to be completed. I want to be able to see what jobs are due for this month, what jobs are due next month and what jobs are due two months from now (seperate query for each of these). I need it to work forever and thus can't use set dates. How would I go...

Hello all . I have a table where I would like the primary key to be automatically generated by Microsoft Access. At present I have the field set to Auto Number(Random) and Long Integer. Unfortunately this gives me both positive and negative values. How can I get Access to just return...