RE: [MS_AccessPros] Stumped....

B,

The question should be "What 'are we' not seeing???"

It would help if you provided at least the SQL view of the query. Why are the tables not linked? This might be a cause for duplicate records.

Duane Hookom MVP
MS Access

________________________________
> To: MS_Access_Professionals@yahoogroups.com
> From: bmorris.gm@gmail.com
> Date: Thu, 21 Nov 2013 17:52:59 -0500
> Subject: [MS_AccessPros] Stumped....
>
>
>
>
> Ok – this is probability an easy answer for people, but it's stumped me….
>
> I have a query that is returning the entry twice…… (yep the same record
> number is repeated)
>
> The query has 2 tables, Master and Budget
>
> Fields in the query include majority of the Master fields and 2 of the
> Budget fields (the 2 tables are not linked)
>
> When the first field (FY) has valid data ("14") searched for, 6 records
> are returned…should only be 3 (other 3 are duplicates)
>
> What am I not "seeing"???
>
> Thanks,
>
> B

------------------------------------

Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/MS_Access_Professionals/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/MS_Access_Professionals/join
(Yahoo! ID required)

<*> To change settings via email:
MS_Access_Professionals-digest@yahoogroups.com
MS_Access_Professionals-fullfeatured@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
MS_Access_Professionals-unsubscribe@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
http://info.yahoo.com/legal/us/yahoo/utos/terms/