ACCESS FEED: Bls: [MS_AccessPros] Re: Sort Ascending Not Run Properly in Append Query

Rabu, 26 Desember 2012

Bls: [MS_AccessPros] Re: Sort Ascending Not Run Properly in Append Query

Thanx Clive,..

But how if the Z table is a Detail table ..? i named the field as ID is just an example, the truth name is [IDR_Det], it's a Link Child Field...so it's really possible to not unique...
But...beside that i really wonder if i change the Append Query to Make Table Query or to Select Query the result is right that the [Data] is sorted ascendingly...
Only Append Query gives the wrong result...

Regards
Hendra

________________________________
Dari: Clive <zctek@aol.com>
Kepada: MS_Access_Professionals@yahoogroups.com
Dikirim: Rabu, 26 Desember 2012 18:24
Judul: [MS_AccessPros] Re: Sort Ascending Not Run Properly in Append Query

Hi Hendra,

Normally an ID Field would be unique. Your Z table
has the value 5 repeated in the first two records.

You should always have a unique field or unique
combination of fields for a primary Key.

Hope that helps,

Regards, Clive.

--- In MS_Access_Professionals@yahoogroups.com, "agesthahendra@..." <agesthahendra@...> wrote:
>
> Hi Everyone,...
>
> I try to describe what i mean :
>
> I have two tables, named Z (as source) and ZZ (as destination), they each has 2 fields, [ID] (Long Int. - indexed) and [Data] (Int. - no indexed),
> i want to append all the records in Z to ZZ, for example i've made 3 records in Z table (as source) :
>
> ID Data
> -- ----
> 5 1
> 5 5
> 6 3
>
> then i made an append query from Z to ZZ, :
>
> INSERT INTO ZZ ( ID, Data )
> SELECT Z.ID, Z.Data
> FROM Z
> ORDER BY Z.Data;
>
> after i ran the query the result is wrong, Still the same as the Z's Records like above... because of the syntax : ORDER BY Z.Data, i think the result should be like this :
>
> ID Data
> -- ----
> 5 1
> 6 3
> 5 5
>
> but if i change the Append Query to Make Table Query :
>
> SELECT Z.ID, Z.Data INTO ZZ
> FROM Z
> ORDER BY Z.Data;
>
> the results are right (Sort ascending run properly in make table query or select query)...
>
> I need to use Append Query, What do i miss here..?
>
> Regards
> Hendra
>

[Non-text portions of this message have been removed]