Search results

Sorry, I attached a file that is readable.

I have a query that pulls a status. Within that status there is a sequence number associated. I want to pull the last status within that dataset, however when I setup my LAST expression it pulls the first date. Here is some sample data below: I want to pull the last status entered. Can anyone...

I am trying to update (2) fields from a temp table to a master table. Both fields are defined as memo, with unicode compression as No. I tried it as Yes as well but get the same error 'record is too large'. Do you have any suggestions to try? I checked the field lengths on characters for the...

Text Fields

I have an append query that is appending to a text field. However, I have some special characters that is causing it not to append because of a data type mismatch. Does anyone know which characters will not append? Thanks for your help.

I have a pickup and delivered date of a package. I need to calculate the difference of the dates with sat/sun only counted as one day. Does anyone have scripts to do this? Thanks for your help.

does anyone know how to upload a file to an ftp location?

I have two queries that I am trying to tie together. I have one that breaks down a parent shipment, and one that ties in the child shipment. They are two separate queries. When I set the query to pull the childs in for the parent, they duplicate. What could cause this issue. Thanks

Worked perfectly. Thanks

Yes, some of the values are null.

I would like to export a table to excel with a default today's date at the end of the filename. Can someone help me, please?

I am trying to add (2) numbers together. I have a sum of transportation charges and Fuel Charges. I tried: [Transportation] + [Fuel] It keeps coming up blank. Suggestions.

Do you have any suggestions?

I formatted them to general number using format([Actual Days in transit],'General Number') same with Commit Times.

I am trying to do a iif function in a query. I have two numbers that I have formatted ([Name], "General Number") and with these two numbers I am getting invalid results. Little history: 1. Number is Actual Days in Transit 2. Number is Commit Time I am doing an iif([Actual Days in...

Team, In need of some help. I have a script that I am using to calculate holidays, however having some issues with it. It is not using the first day after the holiday as day zero. For example, if a shipment is picked up on 5/29 and has a '5' day turnaround, it should be due on 6/8 (excluding...

Have a destination&city field in access and need this to be parsed into (3) fields. Right now I have Dest city, Dest st and Dest zip as columns. I am not sure how to trim or instr what I need? INGLEWOOD, CA 90303 Please help. Shannon

Trying to figure out the best way to determine how many minutes between times in the following format "minutes". ORDER_DTM_GMT: 11/22/2009 1:23:56 PM ORDER_COMPLETION_DTM_GMT: 11/22/2009 1:33:00 PM What is the best format? I have tried several that I have found...but they are touchy when...

Saturday is showing right...i.e. shipped on 10/24/2009 due on 11/2/2009 with 5 day transit...however sunday is not calculating right. I am showing if picked up 11/01/09 due on 11/10, should be 11/09. Thanks for all your help!!

Exactly...so if picked up on sat/sun, monday would count as day zero.