Search results for query: *

I use this VB Code below to export a query as a text file into a local network directory folder. The code works great, but I was presented with a task that I don't know how or if it can be accomplished. In the query, a have a column called Ship-To that has multiple values (ie 130, 132, etc..)...

I have an access query where I have to import data into an excel sheet to sort and group information by it's velocity code and percentage. This is starting to take up majority of my day sometimes. I would like to have a function where it would rank percetages by the velocity code from lowest to...

I have a date column in Excel where some of the row values have null values. I'm using Crystal reports XI. When I apply this code to find the number of days between two dates, I receive an error message with column {Sheet1_.StoreCheckIn} being a Bad Date formate String. I open the excel sheet...

In my report I created a grouping based on the store number. (There's 113 stores) I have a formula column that determines if a service failure has occurred. The formula I'm using is: Name of formula is Service Failure. If {@WorkingDays} = {Sheet1_.DaysOut}then "Yes" Else "No" I'm trying to...

I have a form called frmRTVEditSkuDescription with three unbound controls called cboSkuSearch txtSku txtdescription I’m using an SQL statement to populate txtSku and txtdescription based on criteria selected in the cboSkuSearch control. Search works fine. The problem is if I change the value...

Newbie, I was wondering if an "IF statement" can be included into a select case statement. This is the original case statement Dim strSQL As String Select Case Index Case 0 strTrailerId = Me.txtTrailerReq 'Set variable to trailer Number strSQL =...

If there is no information to display on a report, instead of showing empty fields, is there a way to display a message like "every current"? How does anyone else handle this type of situation?

I'm working on a AS400/DB2 system. I'm new to IBM DB2, and so far I'm not having very much luck. What I'm trying to create a query were the results would insert into a table. I learned that AS400 works with libraries, and I need to show the correct library path. Questions that I have is, I'm...

I'm trying insert query results into a new table. I'm new to IBM DB2, and so far I'm not having very much luck. I'm trying the formula (just to test) INSERT INTO TBLTEST (txtTrailerNumber) (select SSCPGM.WHPMTLDA.TRLR_ID_NO from SSCPGM.WHPMTLDA) but I'm receiving an error message TBLTEST...

Never created a "If" statement in Crystal. Trying to count keyrec's are between 0 to 2 work days. Should the formula be something like Count(IIf({@WorkDays} Between 0 to 2,{iSeriesSQL_FADC_Unfinalized_Keyrec.KEYREC}))

I tried searching on the forum, if I overlooked the answer please forgive. When I input my starting date value and leave the end as current date, the total number of working days is a six digit number. The Start date is based on a three digit (numeric value) concaterize as a date value...

I can't find any references to this error: "On Full Left Cross Inner Right Using Exception" Does anyone know what it means? I'm trying to incorporate a left Join with inner.. SELECT SSCPGM.WHPMTLDA.TRLR_ID_NO AS Trailer, SSCPGM.WHPMTLDA.TRLR_VNDR_NAME AS VendorName...

Yesterday, from reading some references I learned how to create a pass-though queries. I'm having problems converting field values, for example The orginial statement in Access query: SELECT CStr([PO_HEAD_PO_NUMBER]) AS PO, SSCPGM_MPPMPOHA.PO_HEAD_DEPARTMENT...

I never had to create a loop function before. My goal is to perform a validation if cost is greater than retail, prompt a warning message. I'm trying to figure out how to make it a soft error. Just to warn the user, if cost is suppose to be greater retail then the user will select yes, and...

Don't know how the syntax coding should be written. Currently I have a form bound to a query. If I run the criteria expression below for a single date value, the query works. Like IIf([Forms]![frmPalletsFaxedforRA]![EnterStartDate] Is...

I need some help on this request if anybody has time. What I’m trying to accomplish is to have a popup message display if a model number has been pre-identified as salvage. I have a table called tblMainTable bound to a form called “frmMainDataEntry”. “tblMainTable” has data entry fields...

I’m using a combo box on a form where the user can enter a Sku and the item description will populate on an unbound text box. I’m trying to establish a relation in code where if the Sku doesn’t exist, the NotInList event will warn the user and then ask if they want to create the Sku. If the user...