Not sure why this has happened but this has been working for weeks and now i have a problem.
I have a form which i input a from and to date
I used these values in my query as expressions so i would know what date the data was for
Now they are appearing blank. I have tried changing the text box format from short date to blank (text) and this seems to sort the problem but i would like it as short date, it worked beore so not sure why not now.