Search results

I have a table InvPrice and Updated Pricing Need to delete all records from InvPrice that Match UpdatedPricing InvPrice.StockCode = UpdatedPricing.StockCode InvPrice.PriceCode = UpdatedPricing.StockCode I have tried something like this... Dim dbs As DAO.Database, sql As String, rCount As...

This is my passing criteria to query field: IIf([Forms]![FrmUserSelection]![PricingType]=3,1 Or 2,[Forms]![FrmUserSelection]![PricingType]) My field is Pricing Type and holds records 1 or 2 I would like to pass value from my group option from a form. It works fine if group option has a value...

May be I should rephrase my issue I have a query that i need to run from a form. From form I need to pass criteria 1 for canada 2 for us 1 and 2 for us and Canada The criteria needs to go into field Pricing Type. If user selects 1 then only Pricing Type 1 will display. If user selects 2 than...

I need to pass a criteria to a query from my option group control to my query. It contains three options 1,2 and 3. If option 3 then Pricing Type 1 and 2 How do I make the code below working? IIf([Forms]![FrmUserSelection]![PricingType] Like 3,([dbo_AGPricingDiscounts].[PricingType])="2" Or...

Hello, I am just learning access. I need to pass values of my two check boxes on my Form Check box US and Check Box Canada if both checked the criteria would be "UD", "ud',"b","B","us","US","CD","cd" if Canada check box checked criteria would be "cd","CD" if US only checked criteria would be...