Replace function in query with 'Sub Table'

[AceBK]

I am not to sure how to explain my issue, but I will try my best. I am running a query for an apparel manufacturing facility. In my query I have a table called 'OrderForm' which is where the orders are put in. There are more than one type of fabric that can be a part of an apparel item, so as a result, there are multiple fields pulling from the 'FabricType' table. In order to get this to work in my query I created 'SubTables' for the different fabric fields. For example, I have tblFrontfab, tblbackfab, tblsleevefab, and tblcollarfab which are just extra copies of the 'FabricType' table. The actual question is that when I want to replace characters like ,./\& in the fabric field but I can't use the replace function. It says that it is too complex to calculate.

I used this notation
Frontfab: Replace([tblFrontfab].[fabric],".","")
and the error was that it is to complex to evaluate.

I hope I asked the question correctly, looking for any kind of assistance. I am running this in Access 2010

 

[plog]

...which are just extra copies of the 'FabricType' table

I didn't exactly follow what you are trying to accomplish, but doing that means you are doing it wrong. You shouldn't store relevant information in field or table names. Instead when you need to differentiate data, you create a field and put that information there.

Additionally, you can use the same table more than once in a query. If those tables are exactly the same, you don't need them, just keep bringing in FabricType as many times as you need.

As to the code you posted, I don't believe that Replace function is too complex, I believe your entire query is too complex.

Can you post your database?