(Msg. 1) Posted: Thu Jul 24, 2008 2:05 pm
Post subject: Make Table Query - too many rows in return Add to elertz Archived from groups: microsoft>public>access>gettingstarted (more info?)
I am using a "make table query". The table I am starting with has 187 rows.
The return query gives me 163640 rows (each row many, many times).
(Msg. 2) Posted: Thu Jul 24, 2008 2:22 pm
Post subject: Re: Make Table Query - too many rows in return Add to elertz [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Melissa
We aren't there. We can't see your data. We can't see your query. The
question you asked is a little like saying "my car makes a funny noise ...
how do I fix that?"
First, try posting the SQL statement you are using...
Regards
Jeff Boyce
Microsoft Office/Access MVP
"Itzkie" <Itzkie RemoveThis @discussions.microsoft.com> wrote in message
news:C31E5DDC-66DB-42AE-BCC5-89F60C42A47D@microsoft.com...
>I am using a "make table query". The table I am starting with has 187 rows.
> The return query gives me 163640 rows (each row many, many times).
>
> How do I fix that?
>
> Thanks,
>
> Melissa
>
>
(Msg. 3) Posted: Thu Jul 24, 2008 3:56 pm
Post subject: Re: Make Table Query - too many rows in return Add to elertz [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
On Thu, 24 Jul 2008 14:05:01 -0700, Itzkie
<Itzkie.RemoveThis@discussions.microsoft.com> wrote:
>I am using a "make table query". The table I am starting with has 187 rows.
>The return query gives me 163640 rows (each row many, many times).
>
>How do I fix that?
By correcting the error in the query. At a guess, the query has more
than one table included (or the same table multiple times) with no
JOIN line, or incorrect JOIN lines, so that each record in one table
is paired with all of the records in the other table or tables.
Please open the query in SQL view and post the SQL text here.
All times are: Eastern Time (US & Canada) (change)
Page 1 of 1
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Home
Forums
Home
FAQ
Search
Profile
Private Messages
Log in/Register/Password
Office Other