R rarejoep Registered User. Local time Today, 09:20 Joined Oct 8, 2002 Messages 30 Nov 12, 2002 #1 On a report, I want Access to show me all the records till the day today. Does anyone know how I should do that?
On a report, I want Access to show me all the records till the day today. Does anyone know how I should do that?
R Rich Guest Nov 12, 2002 #2 http://www.access-programmers.co.uk/forums/showthread.php?s=&postid=126888#post126888
R rarejoep Registered User. Local time Today, 09:20 Joined Oct 8, 2002 Messages 30 Nov 12, 2002 #3 I've put in the Control Source: =[date]<=Date() where date is the list of dates in the collumn but it results in an error...
I've put in the Control Source: =[date]<=Date() where date is the list of dates in the collumn but it results in an error...
R Rich Guest Nov 12, 2002 #4 It's <=Date() in the criteria section of your date column, you should also change the name of your field from date, it's a reserved word in Access and will cause problems in the future
It's <=Date() in the criteria section of your date column, you should also change the name of your field from date, it's a reserved word in Access and will cause problems in the future
R rarejoep Registered User. Local time Today, 09:20 Joined Oct 8, 2002 Messages 30 Nov 12, 2002 #5 It doesn't work if you put it in the Control Source. It must be in a query?
R Rich Guest Nov 12, 2002 #6 It's easier to do so, the other way is to use the Where criteria of the open report method.
