Search results for query: *

How can I get my report to run by dates between? I want to choose the dates each time. I have two date fields and only want to run reports by one of these dates. I have been to Microsoft's site and looked at FAQ here in Tek-Tips. Thank You so Much, NewCMISGRad

How do I ask the end-user for a date range in a Union Query? I want to prompt by start date and end date to run query or report. Thank You so Much, NewCMISGRad

Sorry. I had my input mask messed up somehow. I deleted it and started over and they all work fine. I always find the answer just after I post something. Thank You so Much, NewCMISGRad

My database will not let me enter dates for any query or report where this is in the criteria: Between [Enter Start Date (Like MM/DD/YYYY)] And [Enter End Date (Like MM/DD/YYYY)] All I get is beeps. If I click on ok for start and end date, it opens the query and report with no data. What do I...

I do have a comment field for each section: Room Comment, Food Comment, Nursing Comment, etc. I have tried your code and it does seem to be working. I still need to check the report for accuracy. Thanks to GingerR for your help. I have quickly looked at Duane's website. I haven't picked it...

That is what I am finding is a problem. Some people may have a complaint and comment about the food and the room. If I just count these and report the counts, I think that would work. But if administration wants to see the comments with the counts, I think I have screwed up. Am I right? [Ponder]...

I hope I can pick up this thread agian. Sample data: Survey ID: 1 Name: Clinton, Bill Unit: CCU Date of interview: 10/5/2004 Food Taste Satisfied Food Temp satisfied Food Variety Unsatisfied Food Complaint: Checked Food comment...

Thanks Thank You so Much, NewCMISGRad

Example: Room Complaints Checkbox Comments Memo Food Complaints Checkbox Comments Memo Nursing Complaint Checkbox Comments Memo General Complaints Checkbox Complaint Dept Lookup box Comments Memo I want to...

Example: Room Complaints Checkbox Comments Memo Food Complaints Checkbox Comments Memo Nursing Complaint Checkbox Comments Memo General Complaints Checkbox Complaint Dept Lookup box Comments Memo I want to...

Right now all that my boss wants is summary information. I will input approx 50 records a week into the table. No my lookup field is not coming from a table, although I have a table with the answers. I will read the evils of lookup boxes as you suggest and re-think my tables. Thanks. Thank You...

How can I get results from fields with lookup boxes on my report. I have a table named Questions with fields of questionID(Number) and RoomTemp(text). Room Temp is a lookup box with choices of satisfied, unsatisfied, Don'tKnow. How can I get a count on a report as to how many people answered...

I have the following tables(shown Below): tblQuestion QuestionID AutoNumber Question Text tblAnswerChoice AnswerChoiceID AutoNumber AnswerChoice Text The question table is filled in with 20 questions. The answer choice table is filled in with 6 possible answers. I would like to...