Search results for query: *

Thanks Terry, That is perfect.

Thanks for your reply, but I want certain months from all years (May 98, May 99, May 00, Jun 98, Jun 99, Jun 00, etc) not just for one year. I thought about it, and put in {like "5/*"} and that gets me all of the mays, then just do ORs for the other months, but I would like to do it...

I have a table, and I want to run a query to select records based on the month. (i.e. choose records for May through September for all the years I have in my database.) My date is formated mmm yy, so I type in the month and year, and it stores the date as the first day of the month. I think that...

I'm having the same problem of it showing all the records. It is fine when the only thing the query has in it is the field that I select the max from. As soon as I have it show more fields from the same table, it shows all records.

DougP, thanks for your reply, but I am still having trouble. The horizontal only show up when needed, but the vertical bars are always there. even if there is only one record in a continous form that has room for 12 records before needing scrollbars. Thanks agian

ihave a subform on a form. most of the time i do not need scroll bars, but sometimes it is large enough to need vertical. i want the vertical scroll bar to show up only when needed, so it looks cleaner when the subform is short. any ideas?

Thanks a bunch! That is suprisingly simple. Cheers, Jeffro

I am a relativly new user who wants a query requirement to be what the user chooses in a combo box. Any help? Thanks, Jeffro