Search results for query: *

You could also perform the code in the oncreate event of the form instead of the onshow, however you will be limited in what you can do in reference to the form itself from this event,as it is, by definition, still being created.

Thanks ! That did the trick.

I need to write an SQL statement for ACCESS for a database with two tables with a one to many relationship I need a query that returns only parent records that have children and return the parent record only once, not once for each child. My query keeps returning the parent once for each child.

I assume that you have also created a association with the .rpt extension to make this work, so every filename will end in .rpt, if so, You could look for the last occurrance of .rpt in the string and know that the file name is everying up to that point, and the paramters are after it.

Your "read back" of my problem sounds as if you understand it exactly, which is suprising because it's often hard to describe something this complicated in an email. I won't be able to impliment it until Monday. I will let you know how it works. Thanks for your quick response.

I need a query to do the following: I have a table I get from my headquarters that has cumulative data in it. I copy the data to another table that I maintain locally with extra fields and records that hold locally significant data. I need a query that will bring over new records from the...