I'm setting up a database and have built a query to collate some data from some tables.
The are different quantities from each data set (as in if I setup a query to find out from two clothing tables which men surveyed wore hats and which women surveyed wore hats) in the table but rather than leaving blank spaces it begins to repeat the 'incomplete' data series.
How can I stop it doing this?? If possible?
The are different quantities from each data set (as in if I setup a query to find out from two clothing tables which men surveyed wore hats and which women surveyed wore hats) in the table but rather than leaving blank spaces it begins to repeat the 'incomplete' data series.
How can I stop it doing this?? If possible?