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

    Report Date

    I know how to put it on evert page however i ony want it on the last page
  2. oldgoldone

    Report Date

    I have a report that the # of pages changes every time i run it and I want to be able to put a date and signature line on the last page any help would be great
  3. oldgoldone

    Help "Newest date Query with a twist"

    I have a querry named "reminder labels" that get data from "Service tabel" & "Customer Tabel' what i need to do is have the query ask the user what "next due dates" they whant to search for then get the "newest service dates" fore each customer I have got the part were the query get the newest...
  4. oldgoldone

    Date problem in a report please help

    I Figured it out Date of Service By Quarter: Format$(Service.[Date of Service],'"Quarter "q yyyy')
  5. oldgoldone

    Date problem in a report please help

    I have this in criteria in my Querry"Date of Service By Quarter: Format$(Service.[DateofService],'q"Quarter "yyyy') it reports as 3 Quarter 2004 at one time i had it report Quarter 3 2004 but i cant remember how i did it any help would be great!
  6. oldgoldone

    New user in need of help with a query

    I have this as a field in my query Date of Service By Quarter: Format$(Service.[Date of Service],'"Quarter "q yyyy')where q gives a number 1-4 is there any way to have it report 1st 2nd 3nd 4th as in 2nd Quarter 2004
  7. oldgoldone

    Report dates

    Thanks alot with your help, you guy that answer these post are great!! I put this into the field name in my Query and it seem to work great "Date of Service By Quarter: Format$(Service.[Date of Service],'q"Quarter "yyyy')
  8. oldgoldone

    Report dates

    I get what you are saying about the use of a combo box but Would that would bring up every date of service all 6897 of them I have them entered in the table in short date format and then i use a query to group them into quarters
  9. oldgoldone

    Report dates

    I am grouping my date by quarter. I am asking the user to enter what quarter "Q2 2004" my problem is in my report I want it to show up as 2004 2nd Qtr can this be done if so can anybody help me?
  10. oldgoldone

    Group Dates in Query

    I have a Query that groups my dates by quarter. My problem is that in my report that i run from the query it display date as Q2 1999, how can i get it to display 1999 2nd Quarter report
  11. oldgoldone

    Combo Box to enter data to table

    Thanks alot I will try it and get back to you
  12. oldgoldone

    Combo Box to enter data to table

    I have to send 3 report to the D.E.P one saying how many gallons of septage one for Holding and one for Grease I have a field for gallons and a field for waist type so when i select grease in the combo it enters "Grease" into the waist type field
  13. oldgoldone

    Combo Box to enter data to table

    I have a Combo Box with one colum that list septage holding & Grease, it enters the selection into the table field Waist type. Now say i want to do is run a reports based on Septage is there a way i can do this sence there is no field named septage

Part and Inventory Search

Back
Top