In my database, I have a table that houses information based on order project. An order project can have anywhere from 1 to 50 orders tied to it. This is just one record in my database, but there is a field that states how many orders go with the project. For average purposes, I would like to set up a query that will show one project number multiple times based on the number of orders (i.e. if a project has 10 orders, I would like it to show 10 times in my query). Is there a way to do that?