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!

  • Congratulations gmmastros 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. lespaul

    Microsoft Query from excel issue

    I am trying to do a CASE statement from a query into Excel. This operation works fine if I am trying to do a comparison on a text field but fails when trying to perform on a date field. For instance, if I do: SELECT Case When CasPre <> 'TR' then 'Not Traffic' else 'Traffic' end From TableName...
  2. lespaul

    ROW_NUMBER() OVER(PARTITION...

    you should just give up rudy! OMG what a mistake! LOL Les
  3. lespaul

    Query Problem

    you're example isn't helping any. Try to use the TGML tags to line up your data: Field1 Field2 Field3 data data data I used the stuff tags to format the above. Leslie
  4. lespaul

    Meeting Several Conditions in a Single Field

    so you want to find all the competencies for a job and then find all the employees that have all the competencies (by meeting or exceeding the LevelReq?) and return the number of employees? Leslie
  5. lespaul

    We laid you off, but need your help.

    @IRudebwoy - That's where I am too! Actually on the Westside of Albuquerque! We'll have to create a Tek-Tips in New Mexico group for the 2 of us! You're the first Tek-Tipper i've found in the area....are there others? Leslie
  6. lespaul

    We laid you off, but need your help.

    @IRudeBwoy - Where in the desert southwest? Leslie
  7. lespaul

    showing extracted date as date, not string

    so you have a table Attendance and you want to count the number of meetings in each month: SELECT Format([MeetingDate],"mmmm yyyy") AS MonthYear, Count(tblAttendance.MeetingTypeID) As NumberOfMeetings FROM tblAttendance WHERE tblAttendance.MeetingTypeID=1 And MeetingDate Between #2010/01/01#...
  8. lespaul

    Copying/multiple instances of sessions/bookings on a course

    can you have sessions without courses? do all users attend all sessions of a course? Leslie
  9. lespaul

    showing extracted date as date, not string

    What are you trying to do with the "date" values of Month and Year? You understand that the value of the date is this: 7/7/2010 7:51 am 40366.32761 where 40366 is the number of days since Dec 30 1899 and the decimal 32761 is the time of day. Leslie
  10. lespaul

    sql database ado out of memory

    you realize that Access "relationships" are only there to enforce referential integrity and to allow Access to "help" you with your queries by automatically...why are you trying to create a relationship through a delphi component? And how can you be using Delphi and not have any code? Leslie
  11. lespaul

    Do you friend your co-workers on Facebook?

    I have a FB account and really enjoy being able to keep in contact with relatives who live in different parts of the country (makes me feel connected to what they are doing and things in their life), people I have met on vacations and some co-workers. Like someone said above, I don't put...
  12. lespaul

    FormatDateTime returning wrong year

    yes but this program was written a while ago and would take major code modifications to change it to a four digit year. roo here's a link to the solution i used. Leslie
  13. lespaul

    FormatDateTime returning wrong year

    Got an answer - now using the TwoDigitYearCenturyWindow and it's working fine! Leslie
  14. lespaul

    FormatDateTime returning wrong year

    I have a form that allows users to enter a date of birth: ie: 4/16/40 Then when the user processes the form there's a function that checks it's length, adds leading zeros, parses the date and then uses FormatDateTime to just return the year of birth: strTemp := strPostedByDOB; If...
  15. lespaul

    Get list folder name in specified folder

    DjangMan, I think the OP wants to be able to put into a TStringList all the subfolders of a specific folder. SOmething like this maybe: var sr : TSearchRecord StrList : TSTringList; begin StrList := TstringList.Create; if FindFirst('C:\MyDOcument\', faDirectory, sr) = 0 then begin...
  16. lespaul

    Concatenate on record in query

    take a look at FAQ701-4233 Leslie
  17. lespaul

    A skilled contractor is thown to side, how to respond.

    But that would be SOOOOO satisfying!!! Leslie
  18. lespaul

    Matching one Table to another.

    you may also want to add a TestingDate field to EmployeeTests so you know what day the person took the test (if that's applicable) Leslie
  19. lespaul

    Matching one Table to another.

    Do you really have your second table set up like Test1, test2, test3,etc? that's not normalized...something like this would be set up like this: Employee EmployeeID EmployeeName Test TestID TestName EmployeeTests EmployeeID TestID Score Leslie
  20. lespaul

    Using Field information in word

    I'm not really clear on what you are asking in your question....do you already have the drop down on the word document and now you want to fill in other fields based on what the user selects OR you need assistance in getting the drop down list populated in the word document? Leslie

Part and Inventory Search

Back
Top