Recent content by JangLang

This is basic I'm sure. Be I'm a newbie so please excuse. I have a query joing two tables. TableInvoice in the query is Product number and Date purchased. TablePrices contains the same fields and contains prices (quarterly) over the past five years. Joined by PONumber, I want the query to...

This is an easy one but I'm fairly new to this. In a query, I have the following data. If a number has more than six digits, I need to parse past the fifth digit and that becomes a new field. If it has five or fewer digits, no record is entered into Column2. For example: Column1 Column2...