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 IamaSherpa 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. gdervage

    How to join two collections?

    One way to do it is to use or. This is what the SQL would look like. SELECT tblData.LastName, tblData.FirstName, tblData.MiddleName FROM tblData WHERE (((tblData.LastName)="Smith")) OR (((tblData.LastName)="Jones")); This is really easy with the query builder in access 97...
  2. gdervage

    How do I grant permissions to a table in Microsoft Access using SQL?

    I would also like a copy of the sample ADO Code. Thanks
  3. gdervage

    Data type mismatch in criteria expression

    Terry, Using Date() didn't help. However I copied the query out of the project data base and pasted it into a new data base and Emailed it to my home. At home I replaced the function call in the query field with the following expression: Expired...
  4. gdervage

    Data type mismatch in criteria expression

    Hi, I hope someone can help with this. I am calling the following function as an expression field in a access query. This is the BOM function Function BOM(dteInput As Date) As Date ' input - a date ' return - a date equal to the first of the month for the input date 'Written July 2001 by Guy...
  5. gdervage

    publish a series of archive reports each week

    Mike, I won't have a chance to try this for the next day or two. I will let you know if I have any trouble. Thank you for answering so quickly. Guy Dervage
  6. gdervage

    publish a series of archive reports each week

    I have a group of reports which I would like to publish weekly and keep a copy of each weeks reports. I am currently using the publish action to publish these reports to a folder. The problem the reports will be over written each week. What I would like to do is publish the report as I am now...

Part and Inventory Search

Back
Top