Access Expression

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Consolidation 1
Overwrite expression-based value in a control 1
Running total on a report 2
Conditional expression help needed. 2
Access Access variable string for export 0
Report values only once 5
Help setting up relationship 21
Expressions in criteria and indexes 5

Back
Top