Access Expression

T

trans

I am looking for an expression that will combine shipments that are in one
day of each other. I'd imagine it is some like + or - 1 day, but am not sure
exactly how to write it. Thanks for your help
 
B

Beetle

You might want to provide a little more information describing what you mean
by "combine shipments that are in one day of each other". We don't have your
DB in front of us, so it's hard to offer any suggestions based on the limited
info you provided.
 
T

trans

Sorry about that, I'm new to this. What I am looking to do is consolidate
shipments. If there are 2 small shipments going to the same destination city
I want to turn it into 1 large shipment. I was able to do this, but only for
same day shipments. I want to expand it by allowing shipments leaving within
1 day of each other (also going to the same destination city) to be combined.
Thank you, let me know if I need to clarify anything else.
 
Top