If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
"Between" and "And"
You haven't given us much information! If I were to do this in a query it would be either: between #01/01/01# and #01/02/01# or =[forms]![form name]![enter start date] and = [forms]![form name]![enter end date] -- The 11th day of every month: http://truthaction.org/forum/index.php "Bill" wrote: I am trying to figure out why the month of August 2007 is generating "too complex" errors in the control source of a text box in a report. This is the formula: "Between" & " " & [Enter Start Date] & " " & "And" & " " & [Enter End Date] When I Enter any combination of dates except for ones that contain "08/01-31/07", it works fine, HELP! Bill |
Thread Tools | |
Display Modes | |
|
|