sequential number (1 Viewer)

WPM

New member
Local time
Yesterday, 22:29
Joined
Feb 23, 2020
Messages
3
Hi dears
i am writing POS system. Sales interface already finished. But i have a problem in which it is with datasheet column named "Line #" . My Data table is Table2 has a field named "Ln". The "Ln" field store line number Ascending order correctly. But in the datasheet "Line #" field it appear descending order.I made many effort to correct it but could not.
Help Me
pos.jpg

WPM
 

jdraw

Super Moderator
Staff member
Local time
Today, 01:29
Joined
Jan 23, 2006
Messages
15,364
??What exactly is the significance of the Line # to you?? Just curious.
Using field names with embedded spaces or special (non-alpha/numeric chars) can be problematic.
 

missinglinq

AWF VIP
Local time
Today, 01:29
Joined
Jun 20, 2003
Messages
6,423
Assuming that your intent is to have first item entered as Line# 1
second as Line# 2
etc.

you must be doing something in the background to cause this...and I don't think we can help you with seeing your file...as sorting can be done in VBA code, Macros, or in the Property Pane...and we'd really be flying blind.

Can you Zip up your file and attach it to a post?

Also note that @jdraw's concern about field names with special characters is well founded, especially as the # symbol has special meaning in Access...it is used in pairs to denote a Date/Time field...and used singly, as in Line #, can be confusing to the Access Gnomes!

Linq ;0)>
 
Last edited:

Users who are viewing this thread

Top Bottom