Search results

This is what I need my report to look like.

I think what I need is a crosstab query (for my report) and these three are summary queries. I had created the two crosstab queries and was trying to joint them into one crosstab query. is this possible?

Thank you so much Ridders. I'll give this a try.

Thank you. Here's the table, two "normalizing" queries and two crosstab queries. The form "select date" has to be open to run the queries. The data (in a temporary table) has the data from 8/5/2018 to 8/11/2018. I am trying to create a report from a crosstab query which shows for each date...

Thanks Ridders. I'm not sure how to create a crosstab query as you suggest giving multiple values for each date (column).

I'm trying to create a crosstab query with multiple values and need some help. I have two crosstab queries (SM and RM) with the following fields: [Meal], [MealLocation],[Date1],[Date2]...[Date7] The value in the queries for each date is the sum of RMMealCount (in crosstab query RM) and sum...

Sorry...got it. I have to place the labels in the "Report" header, not "Page" header.

I have a subreport in which I've placed labels in the header. The labels are not displaying. What am I doing wrong? Thank you!

When you group by a field and you put a textbox in the group's header with the value =sum([somenumericfield]), shouldn't it result in the sum of [somenumericfield] for that group only? I'm doing that and getting some inconsistent results. Thank you!

Perfect! Thanks so much June7.

Thank you. Where do I put the headers "Commuter" and "Non-Commuter"?

Thanks. Saw that but not sure how to get into the format: Commuters: Person1 Person2 Non-Commuters: Person3 Person4 Person5

Is it possible to group based on a value? I have a list of individuals who are either "commuters" or not based on a room number. I want to display the "commuters" on this list followed by the "non-commuters." I've created a query behind the report and one field is "commuter" into which I've...

June7 - you are amazing! Thank you so much. Doesn't need the format BTW.

I need to display all the records (from Sunday-Saturday) on one page. I don't think a totals query is going to allow me to do that. Here's the format for the report: Header (Week of...) Sun Mon Tue... Breakfast Location (RM SM) (RM SM)....(for each day of the week) Lunch Location (RM...

Thank you Mark. I'm not sure I understand what you are suggesting. Is it that I put these calculated values in a query as the record source for the report?

Thanks. I think I understand what you're saying and tried the following: =DSum("[BreakfastRM]","tblTEMPMealCount",[MealLocation]='Location1' And [MealDate]= # " & Format([Forms]![frmSelectDate].[StartDate]-Weekday([Forms]![frmSelectDate].[StartDate])+1), 'mm/dd/yyyy') & "#" but get "the...

I have a report where I am trying to use the DSum() function as the control source for a text box and am getting the error #Name? I can't figure out where the problem is and need some help.:banghead: The table I'm querying is tblTEMPMealCount: MealDate (date) BreakfastRM (integer)...

Thank you! This is great!

Thank you! I've attached a database with table and attempted query.