Query from report that runs a report

[AlfredNor]

sigh

Ok found them all...now when I run I get another error of "Sub function not defined"..highlighting the ObjectExists (down under the green)

 

[Hayley Baxter]

Did you remember to copy the module over as well to your real db? It should be named BasSPTExamples.

Hope this helps
Hay

 

[AlfredNor]

laugh

I bet I didnt...Im not even sure what a module is. Whats the proceedure?

 

[Hayley Baxter]

In your database window select modules (just where you would normally choose tables/forms etc. The module is in here copy this to your real db and that should resolve the error.

 

[AlfredNor]

GREAT!

Yes! It works. Wow - im really learning a lot! Great teacher I suppose

I guess my final question is why the report brings up multiple copies of the same search results?

 

[Hayley Baxter]

It shouldn't do as each record will be unique. You should only get all records listed once for your chosen date. Is this only a problem in your real database? or was the sample doing this as well? I didn't pick up on that if it did.

Do you want me to find that post of mine re the dates?

Hay

 

[AlfredNor]

its in both

Its in both the real and your sample.

The exact same records returned multiple times. They even have the pretty box around them separating each batch. Could this be because of some way I have my data set up?

let me know.

 

[Hayley Baxter]

Hi Alfie

I have sent you an email.

Best Regards
Hayley