Search results

Thanks!...will post back in a bit.

Thank you. I was attempting to do this in the query but can't seem to get it to work. I'll try the report grouping.

Thank you. I think that is giving a count of all the records, not by date.

Data from table: Date Location Breakfast Details 7/15/2018 Location1 1 Gluten free 7/15/2018 Location1 1 7/15/2018 Location1 1 7/16/2018 Location 1 Gluten free 7/16/2018 Location1 1 7/16/2018 Location1 1 Format of Report: Date Location Breakfast (regular) Breakfast (special) 7/15/2018...

How do you want the data - in an attached file or just typed in this message?

I have a table that I want to query for a report but need to do some calculations in the query. My table has: Date (date) Location (text) Breakfast (numeric) Details (text) Essentially, if the field [Details] has something in it, that means this is a "special meal" and I need to count it...

Thank you Mark!

Thank you MajP!

Thank you Cronk! I think I've got something to work (1) Checking if the first meal date is the same as the last and adding records for this date (2) If they are different, set up the first meal date, then do a do while loop to create a record for each intermittent date (3) Checking for the last...

The number attending is not a difficulty. I'm more concerned about the process of how I get from a starting point (first meal date and last meal date) to filling in the information for each day. I don't know how to explain it any more clearly....sorry. If this can be done through an action...

Thank you. Yes, I have a table of events which contains the data. I need to display the data on a form as outlined above for each day.

I need help in creating a loop through a recordset. I have data containing information about event meals. Each event has a start date, end date, first meal, first meal date, last meal and last meal date. I need to loop through the data and create a record in a table for each date that a meal...

Thank you jdraw! That's EXACTLY what I was looking for. (And thank you PBaldy). :D

Thank you. That gives me anything starting after that date. I want to select anything happening BETWEEN those dates. For example: [StartDate] = 1/1/2018 and [End Date] = 1/6/2018 If I select anything starting 1/2/2018 I don't get the above included in the result.

I have a [StartDate] and[EndDate] and I want to select any records that fall between these two dates. If I select [StartDate] >= date1 and [EndDate] <= date2, I don't get the records that have a start date BEFORE the date1 but occurred during this date range. How do I write the query for this...

Thank you so much Mark. I truly appreciate your help. I'll have to look at this when I finish work and let you know how it works. Thanks again!

Thank you. What version of Access are you using? I see an "Fs_Display" but nothing shows up. Is this the form you mean? Maybe I don't the functionality in my 2007 Access(?)

Thank you. Yes, a room can be booked more than once/day. The form is designed to look at one day at a time. I've been struggling with this design for quite some time and can't seem to come up with a solution. Any suggestions would be greatly appreciated!

It still comes up #Name? Did it work on the sample database I uploaded? I'm probably doing something very basically wrong!

Sorry Mark. I was typing my reply when you posted. This is part of a form in which I'm trying to display which rooms are occupied/day and time period. Each textbox represents an hour's time period and will turn "red" when the room n occupied (with conditional formatting).