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

Ok, I understand. What type of query should I use in the After_update event?

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

the program is VB6, i switch back and forth from Access and VB6 a lot, and really don't have that much experience with VB6. Still learning the basics, the main guru who was showing me the ropes left three weeks ago, so it's just me know. When I was reviewing case statement, I was wondering if a...

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?

Thank you for you're suggestion. Trying make table now.

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

thanks, so far this has been a huge learning curve to overcome. i created an access table called tbltest with field name txtTrailerNumber.

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

I'm still receiving ")" is missing error message.

I tried using: Iif ( Between ( {@WorkDays}, 0, 2 ), Count({iSeriesSQL_FADC_Unfinalized_Keyrec.KEYREC}) I received an error message, ")" is missing? Two questions, What is the difference between IF and IIF? What does ")" is missing mean?

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}))

All three fields are numberic values. The date looks like 2/12/7 I tried using the dateSerial function, the date shows as 2/12/7

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

Sorry, using Access

Which area would that forum be found in? I did a find a forum search, nothing populated.