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 Mike Lewis 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. pctechguy

    Adjusting Margins in Outlook Express

    Does anyone know of a way to adjust the margins in Outlook Express?
  2. pctechguy

    Datepart function pulling lastweek of a month

    That is fair and considerate on my part...sorry about that...here you go... SELECT tblweeklyduties.InfraAdmin, tblweeklyduties.Date FROM tblweeklyduties GROUP BY tblweeklyduties.InfraAdmin, tblweeklyduties.Date, Year([date]) HAVING (((tblweeklyduties.Date)=basLastWkDay()) AND...
  3. pctechguy

    Datepart function pulling lastweek of a month

    thanks Michael! This is very close but when I call the function in my where clause on the Date field it only returns the last monday of the current month...I want to move through the table and return the records that match the last monday for each month...not just the current one...is this...
  4. pctechguy

    Datepart function pulling lastweek of a month

    Here are the results from the above query...this is close but how can I pull out of this only the records that have a week date that is the last one for the month...for example...01/26/2004 is the last week of January but 04/19/2004 is not...I know this is a tough one and there might not be a...
  5. pctechguy

    Datepart function pulling lastweek of a month

    I have a table that tracts weekly duties for my department. The weekly duties are dated beginning on monday of each week...I want to "filter" out the last week of a month for each month on the current year. Getting the current year is not a problem year(now()) and I tried doing a...
  6. pctechguy

    Solution for putting a number on a label

    I am trying to number labels on a report I built. The labels have first name, last name, employee number fields included...I also want to number the labels consecutivly (ie, 1,2,3..)and show the number on the report...the report is generated from a table. I have tried to do for...next...
  7. pctechguy

    Degree symbol in Excel

    Figured it out....thanks!
  8. pctechguy

    Degree symbol in Excel

    How do you make a cell formatted for degrees?
  9. pctechguy

    Shading Rows

    Thanks....that worked great!
  10. pctechguy

    Shading Rows

    Does anyone know how to shade every other row in Excel? It needs to be where if you sort the data....the shading stays the same.
  11. pctechguy

    Pulling out Duplicates

    We have a database with employees that have multiple employee numbers because their status has changed from temp to permanent employee. What I want to do is create a group by name and list only employees with 2 or more employee numbers. How can I count just the ones with duplicates? Employee...

Part and Inventory Search

Back
Top