IIf(year="2007",PuraseDate > #1-1-2007#,"*")

[degremont]

the ">" seems not work

 

[boblarson]

That's not the problem. The problem is what you are trying to do with it. What exactly are you trying to do?

 

[degremont]

Table1:
PurchaseDate Field1 Field2 ...
2007-1-10 XXX XXX ...
2007-2-8 XXX XXX ...
2007-3-22 XXX XXX ...
2008-11-10 XXX XXX ...
2006-1-1 XXX XXX ...
2005-8-16 XXX XXX ...

Form1:
ComboBoxPurchaseYear(use to choose year. Value List "2006 and before";"2007";"2008". AfterUpdate me!SubFormOfForm1.requery)

SubFormOfForm1(Base on QUERY1)
Display the specified rows (according to Value List "2006 and before";"2007";"2008".)

For example:
ComboBoxPurchaseYear: Choose "2006 and before"
SubFormOfForm1 display:
PurchaseDate Field1 Field2...
2006-1-1 XXX XXX ...
2005-8-16 XXX XXX ...

ComboBoxPurchaseYear: Choose "2007"
SubFormOfForm1 display:
PurchaseDate Field1 Field2...
2007-1-10 XXX XXX ...
2007-2-8 XXX XXX ...
2007-3-22 XXX XXX ...

How to write QUERY1?

 

[namliam]

Try a search:
http://www.access-programmers.co.uk/forums/search.php?searchid=2318133

This will return (amongst others)
Advanced Search Forms
http://www.access-programmers.co.uk/forums/showthread.php?t=121973&highlight=Search+form

Search Form Example:
http://www.access-programmers.co.uk/forums/showthread.php?t=99353&highlight=Search+form

Query By Form - using Text Boxes and Combo Boxes in criteria
http://www.access-programmers.co.uk/forums/showthread.php?t=103312&highlight=Search+form


Good Luck !