Query

[sms23]

Thanks David for you help earlier. Got it working.

Still need more help.

Now I have a table with the following fields.


Dest Date Pakage Info

PGVA 12-12-01 ABC
RGVA 12-12-01 EFG
PGVA 12-12-01 123
PGVA 12-12-01 154
RGVA 12-12-01 2123
PLIM 12-12-01 123
PLIM 12-12-01 155
RDEL 12-12-01 458
PDEL 12-12-01 145

As you can see there are three destinations here( GVA , DED and LIM) ( in real life would have around 100) and the first letter is an indicator to what kind of shipment it is.ANd all these are leaving on the same day . Need to print all RGVA on one sheet followed by all PGVA and then PLIM( no RLIM for that day) , RDEL and then PDEL.
In other words first sort should be by the three letters following a P or a R and then R before PDoes any one explain problems like me. Signs of a rookie.

Thanks

 

[Pat Hartman]

This would have been a trivial task if the person who designed this table had not stored two attributes (shipment type and destination) in a single table column. If you are that person, my advice is to separate the two and store each attribute in its own column. Otherwise, you're going to have to become very familiar with the Left(), Mid(), and Right() functions to keep separating these attributes so you can use them. It is far easier to store the attributes in separate columns and then join them for printing -
ShipmentType & Destination

Your combos will be shorter since you'll have a simple list of shipment types and a simple list of destinations. If you are doing any editing now, you would need to add n records to your lookup table every time you add a new destination with n being the number of shipment types. Even worse is if you need to add a new shipment type. In that case n would be the number of destinations that you can ship to.

All-in-all, mushing fields together is poor practice and causes nothing but trouble.

 

[sms23]

Gat ya. Let me get back and see if we can change .
thanks