Search results for query: *

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

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

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

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

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

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