Form appears blank when I add grouping to the underlying query

[emreut]

I have a query that uses needs two dates which are entered through a form. The query was working fine to list the items that occur between those dates. When I added grouping to the query the form started to appear blank. The form opens and there are no fields or controls on it. Just the background. What happened? How do I avoid that?

Thanks in advance

 

[bill crumpton]

The problem is the type of relationships that you applied to the tables in the query. Try changing the join types and this should fix your problem.

 

[Carol]

This is also a common problem with fields that you have used as a parameter value and also for grouping purposes. To get around this, create an additional field within your query, referencing the original and use this new field as your grouping field. Example:
Original field = Date
New Field = Date1: [Date] - Use this field in your reports for grouping.

Good luck.