Search results

Hi Jon I figured out how to change the SQL thanks. Your right, that solves the problem but I can't see that it has made any difference to my Query. I guess this must be a weakness in Access and I may have to start familiarising myself with SQL, if I ever get the time. Thanks to all...

Hi Jon Thank you very much for that. Very new to Access and completely uninitiated in SQL I'm afraid. What adjustments do I make to my query to try this? Regards ajak

Hi Neil/Bob SQL Cut and paste: SELECT test1.date, test1.days, [Date]+[Days] AS [Latest re test], * FROM test1 WHERE ((([Date]+[Days]) Between [First date] And [Last date])) ORDER BY [Date]+[Days]; Hope this helps. ajak

Hi Bob Appreciate your efforts. As I said I am very new to Access so not too sure how to "post my SQL". Someone has previously mentioned I should use forms which I appreciate may give me the result I need but I haven't got to the position where I have looked at forms yet. Either way I still...

Hi Brian Thanks for that. I appreciate everyones efforts. Tried renaming all fields eliminating spaces to avoid potential syntax errors but still it doesn't work. Haven't considered form design yet but I can't figure out just what I am doing wrong. Form design may be favourite but the Between...

Thanks Neil. I have set properties on table and on my calculated field to medium date and they all appear to be in European format but still I can't get my Between [ ] And [ ] to work. ajak

Hi Bob Did that and you are right 09/02/08 equals 39487 08/03/08 equals 39515 09/03/08 equals 39516 ajak

Hi Bob Added two new dates in American format into table, 02/01/08 for 1st Feb and 03/01/08 for 1st March. My calculated field shows these at 9th Jan (+7) and 10th Jan (+7) and Paramater query still not showing them when I use either 09/02/08 for first and 09/03/08 for last nor is I use...

Hi Bob Dates entered in European format 01/03/08 etc but I have formated this field in the table as Medium Date so they appear 01-Mar-08 etc. I will change these to American format to see if it work. ajak

Hi Bob Thanks for taking the time to reply. I tried re-entering dates in American format, i.e. first date as 02/09/08 (9th Feb 08) and last date as 03/09/08 (9th March 08) but it still doesn't bring up the expected record containing 8th March 08.

Very new to Access and I have what I guess is a really, really simple problem but I just can't seem to see what I am doing wrong. I have broken my Database down to the most simplistic form to see if it helps but it doesn't. My Table now contains two fields: Date (Date/Time format) and Days...