Search results

Ok, I have figured out where I was going wrong. The issue was to do with the form, [txtStartYear] and [txtEndYear] were not formatted to short date (the format that [Survey Date] was set to), also I changed the if [AllYears] is true value to be a numerical date value. Here is a copy of my...

Marlan, I have looked through the links you sent, and having tried typing it out in SQL it is still not working for me! I would really appreciate it if I could be pointed in the right direction.... This is what I have in SQL: SELECT * FROM tblEnvironmentalData WHERE...

Hi I am struggling to find an answer in the forums... I have a form where users select a site using a combo box called "cboSite", and then either tick a check box called "AllYears" to get all the data available for the site, or enter a year in a field called "txtStartYear" and a field called...