Search results for query: *

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

almost fergot you could do that.. thanks

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

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

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

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

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

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

thanks Paul I think I got it..

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

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

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

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

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

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

nvm.. i got it..

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

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

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

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