[AccessD] Access form and report anomalies

thank you. I checked the underlying queries and they were creating 
duplicate records. The problem was the same query was being used for the 
main report and the sub-report. I adjusted them and the reports now work 
perfectly.

Thanks

David

At 18:23 9/08/2003 +1000, you wrote:
>On 9 Aug 2003 at 18:04, David & Joanne Gould wrote:
>
> > Well, I fixed the tab form. Thanks, Arthur for your suggestion about the
> > subforms - turns that's where the problem was. However, I still can't find
> > any reason for the reports printing in triplicate.
> >
> > Hoping someone can shed some light on this.
> >
>
>Do you have one table in the underlying query with three different
>records (some sort of lookup table?). I'd suspect a missing join in
>the query.
>
>Have you opened the underlying query directly to see whether it is
>creating  triplicate records.
>
>
>
>
>
>
>
>--
>Lexacorp Ltd
>http://www.lexacorp.com.pg
>Information Technology Consultancy, Software Development,System
>Support.
>
>
>
>_______________________________________________
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com