parameter query

[fred4now]

Mike, Donnie, or anybody else for that matter,

I have made querys in the past that when you run them they ask for start and end date. But I can't remember how I made them return all records by hitting enter without entering date.

In the criteria field I have
Between [Enter Start Date] and [Enter Ending Date]

I think I need an Or Is Null but can't remeber how to make it work.

[fred4now]

If anybody cares, I finally figured out how to do this again. It's really nice when looking at data in a time frame.

between [start date] and [end date] or between [start date] and [end date] is null

P.S. Mike, do you have a module that sorts by month like yours sorts by track?

[MikeDee]

F4N, Are your referring to the ROI one thats builds results in a table by track? If so no I don't but it I should be able to figure out how to change it. Send me the module that you are using, I'll change it, rename it to sort results by month.

[hurrikane]

Hey F4N..thought maybe you retired. How goes it with the ponies?

[Glen]

Is this the same thing as setting your query under tDate to
">=10100 and <=123100"
for testing the year 2000? or am I misunderstanding?

[MikeDee]

yes and no, if I am understanding f4n right. I sent him a roi module that would take a given query and summarize the resutls by track and put the roi data in a sepaate table. I think he wants to look at the same data by month. So you can take a query with a data range like 1/1/01 thru 12/31/01 and summarize the ROI data by month.

[fred4now]

Mike, will send module

HK, all is well. Back to spot plays, that seems to be where I can make money. We are moving to new house and still waiting for funding of our new loan. First they made a mistake and now we are in line with all the people refinancing right now. Should have been moved by now, hopefully this week.

Glen, yes if you put that in the date criteria it will give you a pop up when you run your query that asks between what date.

[MikeDee]

f4n
can you resend the test of your email I screwed up and deleted it accidently.

Real Nice job on your estimator....If you ever get tired of landscaping you can become a Access consulant!!!

I ran your view report with the defaults that were in ther....WOW.....that's a few bucks for much:)