Search results

THANKS!!!!!!!!!!!!! I have a field in a table called MyField. For some records this field is populated, for some records it is not populated. I want to run a query that says: Give me all records where MyField Is Null or Give me all records where MyField Is Not Null. I would like to place a...

Is it possible to have as the criteria for a field in a query: [Is Null or Is Not Null?] Where the parameter box pops up, the user enters Is Null, and the query runs using Is Null as the criteria for the specified field? (It didn't work using the above example!) Thanks!! Michael

Works great - Thanks !! Michael

I would like to figure the average without including the zeros. REC# MyCOUNT 1 0 2 5 3 12 4 0 5 3 6 5 7 16 I'm not a great mathematician, so using a calculator, the Average for the above...

There is a property in the combobox called Default Value. Have you tried that? Michael

I guess brilliant minds think alike (and 4 minutes apart!!) I am sincerely happy that it is working, but I would love to know why different combinations DO work? Is it just a lucky coincidence? This is what I mean. #1 -I tried adding a group header AND footer for RequestType. In the header I...

Well, I think I finally have it. I need to try some more test data, but so far it looks right. I added a Group Header AND a Group Footer for REQUESTTYPE. I placed a text box for RequestType and a textbox for InRange in the RequestType Header as INVISIBLE. Then, I placed a text box for...

Whoops, I changed the names to protect the innocent. tbl_TypeOfRequest.REQUESTTYPE is actually STATUS1, STATUS2... tbl_Requester.REQUESTER is the department (DEF Company,etc) tbl_GROUP.GROUPNAME is the Company Name (used solely for the Report header) So based on the results below, #1-...

I have been working on this for some time now, and I am hoping someone can look and it and say: "All you have to do is this......." I have a report "Detail Report of..." based on the below query which works wonderfully - the report is exactly what I need. What I have tried to do is, based on...

Maybe I think you could use an option group. Good info about option groups in Help Files. HTH Michael

&&&&&&&&&&& Man, I did it again.... those darn ampersands !!:o Thank you VERY much bjackson for your help. Of course, it works wonderfully !! Michael

Unbound form - frmABC Textbox - txtBeginDate Textbox - txtEndDate Report - rptReceived I would like a textbox on the report's page header to read: Accounts Received Between xx/xx/xxxx and xx/xx/xxxx I just can't seem to get the syntax exact. I have: "Accounts Received Between "...

Thank you very much :) Michael

Simple query. Field: CompID In a query - drop the field to grid. Criteria line - [Enter a CompID] Works great when user enters ONE CompID. What I would like, is for the user to be able to enter 1,2 or 3 CompIDs as the criteria. How do I do this? :confused: Thanks! Michael