expression

I'm trying to multiply a cell with a constant and that has a non-numeric value. Example 15" (" = inches). I used the "Left" formula and it works. However, the data changes in size and would have to change the value of the Left formula from 2 to 4. Is there a better way of doing this? Like an...

Hi Guys, I have two columns in a "Customers" table: "Cust" and "Cust_Adr" which are the Customers Name and Customers Address. The postcode is included in the Address column and I want to extract the Postcode and then return results where the same postcode appears more than 5 times. So I tried...

Can you toggle a button and run the code behind it by clicking another button? For example, I have a print button that once is pressed to make sure two other toggle buttons are also clicked and ran to hide unnecessary work. I don't know the expression to run code in a button where the code is...

Hi I need some help with the below sample code. Is it possible to use a variable as a case expression? I have the following code that works. For Each PivItem In _ PT2.PivotFields("Brands").PivotItems Select Case PivItem.Name Case "Cola", "Pepsi", "7UP", "Fanta"...

Hi Im new to Access and am now very stuck so any help would be fantastic. i have put the following into the zoom box of an empty field of my query Profit %: [profitvalbase]/[costvalbase] this returns a "this expression is typed incorrectly or is too complex" message however and both are...