Splitting one record into multiple records

[rwilson]

I have created a query that selects records based on any one of 21 fields in each record being less than 3. However, I now want each record to duplicate itself if there are multiple fields that are less than 3. For example, a scaled down version of this query would have fields called station, station_no, zone, greeting, and safety. The greeting and safety fields are the ones with a criteria of less than 3. If they are both less than three, I want the record to duplicate itself with one row showing the station, station_no, zone, and greeting fields - and the other row showing station, station_no, zone, and safety fields. Any suggestions? I keep hitting walls with this one.

 

[dakcg]

Try changing your joins. Most of the time, the join is for fields in both tables where the joined fields are equal. But if you want some information from one and more info from the other, change the joins to match your criteria. Just a thought
dakcg

 

[dakcg]

Or, you could try using temp tables. Create a query that has the info you want, and create a table based on that info. Do the same for the other info, then do an append query to tye the two tables together. Just another thought.
dakcg