Recent content by scgoodman

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