This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
I have a field in TableA called “ProductSKU” which is a primary field that concatenates some data from other fields in TableA. The formual is: LEFT(Description,10) &"-" &FinishCode &"-" &Model
I have a field in TableB called “SelectKit” that is a l...
Hi everyone; I use different parts from different vendors to create new products that I then offer for sale online. I do not need to track sales, payments, or customers in my database. I do need to track an inventory of parts that are used to make pr...
Thanks, but I’ve resolved it by removing the offending LEFT({SelectKit},5) field from my formula. I still have no explanation, but I am 100% absolute that there is no quotation mark in any of my fields, so it was being arbitrarily generated by code. ...
Thank you for your guess. Yes, that would be my first suspicion as well. But, as I’ve already stated, that is not the case. That has been double-checked, triple checked, and then reconfirmed… There is NO quotation mark anywhere in any field involved ...
Klaus, Not sure that my actions qualify as “solutions” yet, but here’s what I have:
An ASSETS1 and ASSETS2 tables that contain the parts I use to craft products. (might merge to one table)A PRODUCTS table that pulls via links from the ASSETS tables t...
Okay, realizing that my first query might have been asking a bit too much from even the most helpful of forum members, I dove in head first and have managed to get done almost all that I needed to. Mostly, the challenge is semantics. I do have one st...
