Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. 123451238

    How can I use DateDiff-function in MS Access SQL?

    I have tried to use the DateDiff-function to determine how many months there between today and the day a contract is signed. In the query, I write the following: DateDiff(month;Now();SignedDate) MS Access 2003 won't accept eithter "month" nor "m" as the first attribute. Is there a way to...
  2. 123451238

    Multiple NOT EXISTS query

    I have a database in MS Access 2003 to do the regular operations for administration in my office. I need to make a query in SQL to find out which employees who have been working with all the projects involved with a certain building. The relation is like this: EMPLOYEE - PROJECTPARTICIPATION -...

Part and Inventory Search

Back
Top