Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Jeremiah31

    Exporting query into multiple text files

    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..)...
  2. Jeremiah31

    Rank by velocity and percentage function

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

    Bad Date formate String because of null values?

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

    Calculating a Percentage withing a grouping

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

    SQL Update Recordset Problem

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

    SQL Update Recordset Problem

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

    Case statement using an IF statement

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

    Case statement using an IF statement

    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 =...
  9. Jeremiah31

    Need a Suggestion

    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?
  10. Jeremiah31

    AS400/DB2 system

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

    AS400/DB2 system

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

    Insert query results into a new table

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

    Insert query results into a new table

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

    Count If Statement

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

    Count If Statement

    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?
  16. Jeremiah31

    Count If Statement

    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}))
  17. Jeremiah31

    Working Days Mis-Calculating

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

    Working Days Mis-Calculating

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

    JET-SQL Error: On Full Left Cross Inner Right Using Exception

    Sorry, using Access
  20. Jeremiah31

    JET-SQL Error: On Full Left Cross Inner Right Using Exception

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

Part and Inventory Search

Back
Top