Search results

Solo, thanks for your help the only problem i have now is that My PriceCode could be upper or lower case. How can I make sure that it will only query records with same PriceCode with same Case?

please check for attachments

I need to delete records from table dbo_InvPrice which are equal to records in UpdatedPricing table The two tables could be linked by primary keys stockcode and pricecode I have uploaded two attachements. Thanks

My table UpdatedPricing is already a select query, now I need to delete all records from dbo_InvMaster when the records have same StockCode and PriceCode. Can you see the attachement?

Well another error,"specify table from which you want to delete the records. I want to delete records from table dbo_InvPrice This is what i have Dim dbs As DAO.Database, sql As String, rCount As Integer Set dbs = CurrentDb sql = "DELETE * FROM dbo_InvPrice Inner Join UpdatedPricing on...

Yes you are correct. Error = 3075 Syntax Error Syntax Error / Missing Operator

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...

if user selects option 3 i need to pass 1 and 2 if user selects option 2 i pass option value if user selects option 1 i pass option value My field where i pass the criteria only has value 1 and 2 so if user select option 3 i had to change it to 1 and 2 (all) If i don't change the 3 query has...

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...

I am using this code in criteria, what is wrong it's not taking 1 and 2 if the Value from option box is 3. IIf([Forms]![FrmUserSelection]![PricingType]=3,([dbo_AGPricingDiscounts]![PricingType] In (([dbo_AGPricingDiscounts].[PricingType])=1 Or...

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...

Thanks, this is what I am just doing. My option values are 1 or 2 or 3 I need to select criteria of Pricing Type based on my option value selection. My pricing type in a database could be 1 or 2. If option value 1 then I am passing Forms!FormName.ControlName (which is also 1) this would work...

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...

Sorry I have to work with what i have,can't change the Database structure.

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...