Adding a record

[Skotor]

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!

 

[dcx693]

Not sure why you want to do this....but you could probably "trick" your query into displaying the same line twice if you join it to a dummy table that has 2 fields (multi-check and sub loc ID) and 3 records with the following values for multi-check and sub loc ID: -1,a and -1,b and 0,<null>. Do a "normal" inner join and I think it should work out.

 

[Skotor]

That did exactly what I needed it to do. Was making it harder on my self than I should of. Thanks!

 

[dcx693]

Great! I don't think the solution was all that obvious (not that I'm all that brillant), but it's not something you'd learn in an Access manual. So you probably weren't making it harder than necessary.