Search results

Found the issue.... placed a sample data to test it and found that i was calling something that should not be called in the expression. imgetting a mismatch =SUM([TotalInspectTime]) and if i do #" and "#" i get an invalid date value... that should be # right? since its based on dates.

yup. the datediff gives out what i want (days, hours, min, sec) no problems on that... its when i sum it as an aggregate that it gives out the error. for the heck of me, i dont know where or what im doing wrong.

Already did that: On Query: TotalInspectTime: datediff(..code..) then on the report field =Sum([TotalInspectTime]) still an error.

redid the code but still an error on the field. =Sum(IIf(Len(Trim(DateDiff("d",[inspect_Start],[inspect_End]) & "d, " & DateDiff("h",[inspect_Start],[inspect_End]) Mod 24 & "h, " & DateDiff("n",[inspect_Start],[inspect_End]) Mod 60 & "m, " & DateDiff("s",[inspect_Start],[inspect_End]) Mod 60 &...

yup... but its giving me an error.

I need help on a sum expression problem. I did a seach and noticed that there is another post on the issue but they dont resemble my own. Hoping anyone can help me out. The problem is that, on a report, i have an field that calculates the difference between inspect_start and inspect_end both...

Build the filter on a form...create unbound fields for fields that you want it to filter. Then create a button and put the filter code on the button's onclick field.

Things to learn for me. Thanks again.

Leathem, I would have one query that will have all the fields and build a report based on that one query and pull it via a filtered report.... you can look at Bob's sample of reports on how each one should be coded. eg. number, etc... also, I had my header blank as i have multiple filters...

Thanks again. Super Bob!!! :D quick question... why string vs variant datatype?

need help on a connector. I have a form that filters the report prior to preview. With the current code, it replaces what has been valued first when both filters are valued. Can someone point out the direction of how this can be done or what I am doing wrong? current code: stDoc =...

I didn't notice that.... cboReport is the field name. Thanks a million. Happy New Year.

fhs... the report works fine for me too. I didnt see #name

Thank you for the reply Bob. Based on what you had sent... used it as a guide and created this ( see code below ). Now i am getting a 2103 runtime error. Also, can you do stDoc="field name"??? Dim stDocName As String Dim stWhere As String Dim StDoc As String StDoc = "Me.Report" If Not...

can someone guide me on how to dynamically change the output of a filtered report based on a combobox. DoCmd.OpenReport "Build by Status", acViewPreview, , var I want the user to be able to select which report (Build by Status, Build by Priority and Build by Contractor) to open and apply...

I figured it out. Had to redo a filter to show the 2nd column not the first (numeric). and changed the code to refer to it. All is well now. Thank you

Thanks for the reply P. But i am already doing the filtering on the code posted. My issue is not on the filtering process per se; but more of how to do a variation of it - given that my source comes from a table where the fields have been split. e.g. Contacts Table - ID(numeric Primary Key)...

Hello again my Friends. How do you perform a filter for a report based on a field thats based on a numeric primary key that corresponds to a text field. Hopefully, i explained myself well. here is the problem: I have a form that does two things ( with two buttons ) one button for search...

Thank you All... been looking at it and just figured out. two words - string variable. lagbolt - yup yours will work too. it has the same string variable requirement. but already solved it - it was right under my nose. Thank you all again.

Exactly... and i cant figure out why... and where its coming from. so i redid the code to this ( see below ) which does the same thing Private Sub Preview_Click() Dim stDocName As String stDocName = Me.Category If Me.Category <> "" Then DoCmd.OpenReport "Issues by Status", acViewPreview, ...