Recent content by lespaul

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

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

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

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

@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

@IRudeBwoy - Where in the desert southwest? Leslie

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

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

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

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

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

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

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

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

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