Search results

Hi I have a report that list all customers. My only problem is that it only orders them by the first number of their address because it has the street name as well. Eg: 1 Bedford Street 22 Bedford Street 3 Bedford Street and so on. I did have the the number and street address in seperate...

hi just wanted to say cheers to all help on this - problem has now been resolved

i want all empty fields to be displayed- as this would mean here is no holiday set. cheers

next conundrum - your function works fine but if they say have only one day and the to and from date is the same it doesnt recognise it and still gives a positive result.

Brianwarnock: Im not sure -doing it that way on the first field worked fine but putting it on the 'till' field it didn't work - not sure if its because some of the fields are empty if there is no holiday. I tried it with <>Date() OR is Null but still didnt give accurate results. KeithG: I think...

this is perfect - thankyou for your help. I have another query - i have a sub form in the main customer screen which has a small table holding the holiday dates - I have them linked by the custRef field but when i add a new record i get this error: You can't assign a value to this object. *the...

sorry - not to seem really thick but my two values [Holiday_from] [Holiday_Till] Where would i put them in the above function?!!!!

thats excellent - i'll give that a go and let you know how i get on many thanks for your help

hi thanks for the reply. It is in fact as you say - the re is a from and till date. My only problem is now getting it to not display that record while the current date is still between the from and till date. Any ideas

One the face of it it sounds quite simple - i have a table that holds various bits of info about a customer but also a field that contains a holiday period - what i want to be able to do is show all records that do not equal todays date. So if today was 11/04/06 - and one of my customers had...