Search results

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...

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

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.

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...

Any suggestions and best practices on the following. I have commit times (which are days). I need to calc the end date based on a start date and the number of days added. Excluding weekends and 10 us holidays. Example. Start date is 9/7 and needs to be delivered in 6 days. So I need to...

Trying to count records in a field CUST. These records will be separated by a comma and sometimes the field will be blank. i.e. CUST REF 80908766, 723767676, 787987987 23432434, 342343432 I want to show that there is 3 entries in that field for the first record and 2 entries in that field...

I have a linked table in access to sharepoint. I am trying to run an update query to update one field. It worked, until I had to rewrite the query. I didn't change anything as far as format, what could cause a lock violation issue? Any help is appreciated.

I have data that looks like this '006JFK74901702' and I want to remove the JFK. Sometimes the field can be null. How do I remove?

DateAdd Functions I am trying to perform some date due functions, however have an issue with it. I am performing a DateAddW expression, however...I need to account for Sunday's and Saturdays. See table below. TAT Schedule Examples attached.

Trying to do a dateadd in hours in access and if one of the fields that needs to be populated to calculate this field is not populated I get an #Error message. How can I just show this as blank?

Trying to do a date calculation. I have two dates, Delivery Date and Due Date. I want to show whether it is ontime. Date format is MM/DD/YY 6:34PM for both. I wrote this statement: IIf([Due Date]<=[Delivery Date],'No',IIf([Due Date]>[Delivery Date],'Yes')) This works, however if the due...

I have a received time... 1/31/2009 14:00:00 PM I need to default this time to a standard. So if the time is on or before 16:00 PM it defaults this time to '1/31/2009 4:00:00PM' and if it is greater than 16:00 (i.e.1/31/2009 18:30:00 PM) it defaults back to 16:00 PM. Please help!