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: Dre313
  • Order by date
  1. Dre313

    report counting..

    I have a form which pulls records in for different areas.. The user enters in dates, the area they want to see records hit a button and a report comes up displays the information for that site and for those dates. My question is in between those dates are other records from other sites.. I want...
  2. Dre313

    Form to Report Help...

    almost fergot you could do that.. thanks
  3. Dre313

    Form to Report Help...

    I have a form which searches for records ... When the user hits enter another forms pops up and ask for your name and the company you work for.. The user enters in the information hit ok and the form closes and a report of the records the user ask for pops up with the users name and company on...
  4. Dre313

    Counting Module

    duh..I think I got it.. just came to me.. I already have "Y" in the mod.. wat a ding dong i am hehe thanks for your help
  5. Dre313

    Counting Module

    Heres what I did.. I think we might have to seperate.. the function3 on its on... so I tried this.. Function funCount3(prmSearchString2 As String) As String funCount3 = DCount("[INSP]", "[qryQualityStatus]", "left([INSP],2) = '" & prmSearchString2 & "' And...
  6. Dre313

    Counting Module

    what Am I suppose to write in the txt box of my report for the second one ?? the first one reads.. =funCount1("DR") how would the second look? I tried =funCount2("y") That doesnt seem to work.. an Enter Parameter funcount2 comes up.. what did i do wrong ? thanks
  7. Dre313

    Counting Module

    If i were to do that as you suggested.. I believe I would come into some problems.. for I need two sets of numbers.. my first number would be a count of all records .. within a specified date range.. with a match of "DR" in my INSP field... if I add all REJ of "Y" into my...
  8. Dre313

    Counting Module

    I have a module .. that counts the first two letters in my field "INSP" module: Function funCount1(prmSearchString As String) As String funCount1 = DCount("[INSP]", "[qryQualityStatus]", "left([INSP],2) = '" & prmSearchString & "'") End...
  9. Dre313

    easy question....

    thanks Paul I think I got it..
  10. Dre313

    easy question....

    thanks paul i'll try this.. one thing.. what is attempts ? tblResults.. would be my table Date .. would be my date field.. Attempts ?? CountofAttempts ?? thanks
  11. Dre313

    easy question....

    Yes.. and it returns all blank dates.. but is there a way i can count how many are blank.. and give me that number ? thanks for the response..
  12. Dre313

    easy question....

    I fergot how to count all null field in a query... First I'm tryin to get all "Y" in a yes no field ... so in my query I add my table then add my field .. i put the letter Y in the criteria.. and it pulls all "Y" yes for that field... Next I add in my date field.. which...
  13. Dre313

    pulling records off combo field

    On my form I have a subform.. On the form I have the combo box.. with the listings on top.. when i choose AB1 it returns all records in my subform with the value of AB1.. AB1 is in a field along with other fields in the record.. What I want is.. if the user selects AB in the combo .. it'll...
  14. Dre313

    pulling records off combo field

    Hi, I have a combo field with data from a table.. as follows.. AB AB1 AB2 AT AT1 AT2 AF AF1 AF2 etc...... I have a form and a subform inside.. when the user selects AB1 in the combo box and hits a button it returns all records with an AB1 on it.. What I want to know is .. when the user...
  15. Dre313

    record count

    I have a group of records .. With fields "OpenDate" "CloseDate" "Rejection" and "Inspections".. Inspections in a combo box that has data like.. DR, DR1, DR2, PS, PS1, PS2, PF, PF1, PF2, PF3, PF4 ETC.. ( DR-Design Review, PS-Pipe Shipment, PF-Pipe Fitting )...
  16. Dre313

    how to add fields together on my report..

    nvm.. i got it..
  17. Dre313

    how to add fields together on my report..

    Ok this is what I have changed.. I add the code inside my detail section of my report.. and it worked.. but when i go to the footer section of the report and add the same code.. i get an error.. .. does anyone know of a fix ? thanks
  18. Dre313

    how to add fields together on my report..

    I have a report.. which has some text of numbers.. I want to add all the numbers up and display it on my report.. I tired in my report.. adding a unbound text box to the footer of my report " =Sum([MIL]) " I get error in return... I'm sorta new .. thanks for baring
  19. Dre313

    SQL help ! thanks

    I can't seem to find the "(" which should ")" ...... I have 12 parenthesis all together but.. theres one more "(" then ")" I can't seem to find it.. can anyone else see it ?? thanks
  20. Dre313

    SQL help ! thanks

    I tried the code mentioned above... I getting a different error.. this time I'm getting.. Missing ),], or Item in query expression.. any ideas?

Part and Inventory Search

Back
Top