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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by simon10

  1. simon10

    EXISTS and BETWEEN dates

    that makes sense. Thanks you so much for your help and time with this matter
  2. simon10

    EXISTS and BETWEEN dates

    actually - just noticed the typo I added! It works!!! many thanks for your help A quick explanation of it would be much appreciated thanks again
  3. simon10

    EXISTS and BETWEEN dates

    Many thanks for your reply. I tried the first one and this only returns the properties that have entries in the availability table. I need it to return all properties in the property table except those whichhave entries corresponding with the date range 9start and end date) I could not get the...
  4. simon10

    EXISTS and BETWEEN dates

    I would be so grateful for some help as I have been stuck on this problem for a while. I have two tables: "properties" with columns - property_id, property_name "availability" with columns - avl_id, property_id, date eg.. property: 1,house 1 and avl: 1,1,2008-12-20 The availability table...
  5. simon10

    Maintaining field types when using linked tables

    Thanks for the reply. So I set up the table with the field types as I want them and then have to import the data in from the spreadsheet each time I update the spreadsheet in Excel. Is this correct? Thanks
  6. simon10

    Maintaining field types when using linked tables

    Hi, Just wondering if someone can help me with a problem I am having when using a table that is linked to an excel spreadsheet. I am doing some work for a client who wants to use an excel spreadsheet to update the data in an access table. I have linked the spreadsheet to the table and the...
See more

Part and Inventory Search

Back
Top