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: *

  • Users: PQTIII
  • Order by date
  1. PQTIII

    date range ??

    I want to set up a report to run from the first date of the month to the day before the current date. What is the formula that represents the first day of the current month? Thanks pt Cr9
  2. PQTIII

    Rotating Year Formula???

    I want to run a report that captures data with a date range of today's date from the same day but a year ago. I guess I'm looking for a rotating year each time the report is ran. What is the best way to accomplish this??? Thanks Paul CR9
  3. PQTIII

    date function

    Worked great! Thank You pt
  4. PQTIII

    date function

    I want a field to default to the 1st day of the current year. What is the date function for that? Thanks pt
  5. PQTIII

    highlighting

    Bob That changese the color, but I want to change the highlight color. DO you know how I would code that? Thanks pt
  6. PQTIII

    highlighting

    I need to write a formula with if statements. I need this highlighted different colors and the format wants numbers only. If left({equipnum},2)="MD" and {duration}>"00:02:00" then highlight yellow {equipment} else if left({equipnum},2)="MA" and {duration}>"00:04:00" then highlight red...
  7. PQTIII

    highlighting

    I have a couple of things I need to highlight based on a couple of criterias. What is the word you use to highlight a field? Say, if I wanted it to be highlighted yellow. Thanks pt
  8. PQTIII

    select data with only 5 places

    PERFECT, thank you so much! pt
  9. PQTIII

    select data with only 5 places

    I want to list only the rtrim[operid] that contain a 5 digit string. I used operid like '_____' and it list all 5 digit operids, but it also list 4 digit ones. select distinct rtrim(OperId)as OPID , rtrim(OperName) as OP from vWorkers where OperName is not null and OperId like '____' order...
  10. PQTIII

    counting events

    I have a year to date report that is grouped monthly. For each month I want to know how many days have total units sold over 1000. How would I use the count finction to do this in a text box? Thanks pt
  11. PQTIII

    Subreport links for date ranges???

    Is it possible to use a date range as a subreport link?? In my main report I have a field that totals fuel usaged for individual trucks then it goes to a subreport linked by truck. I need it to use the same date range as the main report uses. Thanks pt CR.9
  12. PQTIII

    Converting datetime fields???

    Is there a way to convert datetime fields to just date fields. I use a datetime parameter and in my database for some reason they use a datetime field that never changes from 12:00:00AM. When you use the parameter for a search unless you put the 12:00:00AM it misses the dates you want. This...
  13. PQTIII

    Blanks fields to zeros???

    worked perfect!!! Thanks pt
  14. PQTIII

    Blanks fields to zeros???

    I've never done an update before! If have table 'SurveyPoints' and want to update the field [elevation] that contain nulls with zero. How would I write that statement? Thanks pt
  15. PQTIII

    Blanks fields to zeros???

    Where and how do you do the update code? Thanks pt
  16. PQTIII

    Blanks fields to zeros???

    I added a number field to a record , but it shows blanks in the table for the old records. Is there a way to convert all of those blank fields to show 0 without putting a zero in each field by hand? Thanks pt
  17. PQTIII

    text box queries??

    I copied your statement and it brought up the same number mine did. I used the expression builder and picked the textbox for the calculation and I still got the #Name? error. Am I doing something else wrong? Thanks Paul
  18. PQTIII

    text box queries??

    When use the testbox "totlbs1" the Dlookup works fine, but when I use it in another textbox "calc" for a calculation it gives a #Name? error. "totlbs1" =DLookUp("SumOflbs1","Blast Product","[shotid]=[Forms]![NewMain]![shotid] and [pattype]=[Forms]![NewMain]![pattype]") "calc" =[totlbs1]*1.34...
  19. PQTIII

    text box queries??

    That worked great, but once you get it how do you reference that text box value to use it is calculations? Thanks paul
  20. PQTIII

    text box queries??

    Remou Can you have multiple criteria on Dcount? If so how do you do that? thanks paul

Part and Inventory Search

Back
Top