Table Field Text From Query Field

[cmoney33]

Hi,

I've got a query which I use to compile several fields dealing with account locations and territories. I am trying to get a field in the CompilationQuery, which is called TERRITORY, to enter the results of the query into the TERRITORY field in the AccountLocations table. I am trying to use the AccountLocations table, which already exists, to export data to excel including the TERRITORY field. The exporting part works already, just need help getting the fields from the query to the table.

Any help on this would be greatly appreciated!

Thanks

[cmoney33]

After consideration I think the root problem might be what is causing the need for this. I am using check boxes to build territory codes in a form tied to the AccountLocation table. What becomes the territory code must all be in one field for each account, TERRITORY. I use the CompilationQuery to combine codes from each TRUE check box into a single string which I am then trying to get back into the AccountLocation table in the TERRITORY field.

If there was a way to compile this in the AccountLocation table then I would not need to use the CompilationQuery. The compilation process adds a specific text value to the TERRITORY field if true. For example, assume there is are North, South, East and West TERRITORY fields. If a specific account needs to overlap in both the North and West territories then the TERRITORY field would have a value like: NO-SO . This necessity to compile various territory combinations makes a list box unviable.

I'm not sure if this helps, but if there is a way around either of these two scenarios it would be great.