OBP

Hi OBP,

Left you a message on gmail.

Thanks Garth H

Hi OBP,
I was away for awhile fishing. Thanks for responding to my thread. The two queries were the key. I had to make the join a 1 to many. worked like a charm
Thanks Much,
boaterjohn

Hi OBP. Greetings from the south. Do you still have your Gmail address? Garth H

HI OBP,
how are you? i think you could remember me we work together last year for one thread called "MS access query". I have attached the file too with this message. Now i am facing a big problem in the database while running that macro its generating more space and database size became more than 2 gb. As you already know 2 gb is the maximum size of the database.

Kindly let me know if there i can do with this macro or u can help me on this. I know the problem would be like the data volume is huge (approx 4 million).

Regards,

Vinoth S

If the dates for the query come from a form, then use
=forms![Formname]![Enter Shipping Begining Date:] etc.
If they are not I suggest that you put them on a form.

Hi OBP,
Help again pls.
I was trying to figure out how to setup Date range in report header.
I got to setup query date range but on my report I setup text box on controlsource I put this: =Format([Enter Shipping Begining Date:],"mm/dd/yy") & " through " & Format([Enter Shipping End Date:],"mm/dd/yy"). then after I tested by entering date and is not showing on report header its says' #Name? on text box. I need your assistance. Thanking you in advance.

Just wanted to leave a message saying that OBP is superman. Thank you for your help and making my idea happen with my data on excel. This member is amazing, what goes around comes around in one way or another. :-) Thank You.

thank you for the example database! I'm late, but you know what they say, better to copulate than never.

I have looked at the Relationships and they are Ok for now.
I will post what you want shortly.

Ok - now I am confused, got feedback from RockN and once again I am lost? I didnt link fields - agge nee - and I thought it was working.. Seriously.. thought I was getting the hang of it....