I've used the search function on the forum and couldn't find what I needed so I'll give this a shot at explaining what I'm trying to do and if there is a way I'm over looking...
I have a database with various location data keyed on a location number. There is one field that is a yes/no check for if it is a multi-unit location. Is there a way when running a query that if this field is true, it would list that location again? I would also want to creat a sub loc ID, but just getting it to give me 2 records in the query would be a big step. Ideally I'd want it how I have it listed below.
data:
loc / multi-check / other data
001 / 0 / ###
002 / -1 / ###
query display:
loc / sub loc ID / other data
001 / / ###
002 / a / ###
002 / b / ###
Any hints or and pointing in the right direction would be a great help. Thanks in advance!
I have a database with various location data keyed on a location number. There is one field that is a yes/no check for if it is a multi-unit location. Is there a way when running a query that if this field is true, it would list that location again? I would also want to creat a sub loc ID, but just getting it to give me 2 records in the query would be a big step. Ideally I'd want it how I have it listed below.
data:
loc / multi-check / other data
001 / 0 / ###
002 / -1 / ###
query display:
loc / sub loc ID / other data
001 / / ###
002 / a / ###
002 / b / ###
Any hints or and pointing in the right direction would be a great help. Thanks in advance!