Sort Before Appending the Last Record

[ooch1]

Hello,

I have just quite worringly discoevered that my append query isn't working as i'd hoped.

Basically, in the design view i have sorted the data (or so i thought) by contract number and then appended the data by the Last value.

The worrying thing is that the sort seems to have been erradiacted, or at very least is secondary to the picking the last row.

Is there anyway i can ensure the data is sorted before the last row is selected, or do i have to create additional queries that sort the data first, as this will be a real pain.

E.g
Ctrt_Num Mtr_ID
12345 700
54321 700
12345 700
12345 700

What i would like is for the data below to be returned, instead of the last row of the above.

Ctrt_Num Mtr_ID
54321 700


Cheers

OOch

 

[ZmrAbdulla]

As I understand you are mistaken the datasheet of table as EXCEL spread sheet where you can insert a row and enter the data.
In Access what ever you add as new record goes to the last of the datasheet.
Just run the append query and sort afterwards. Your data will be as you like.

________________________________________
Zameer Abdulla
Visit Me
There is only one perfect child in this world. Every mother has it.

 

[ooch1]

Thnaks For the fast response, but I would only like to to append the last row based on the data sort, as the other elements are no longer valid.

I was originally hoping to do it as part of the same append query, but i think i will have to add in another step, my data is only being sorted after the last row has been selected.

OOch