Search results

I am building a form with the list of report and parameters, so user can select it to run a report. Can anyone provide a good sample of form with difference date parameters such last month, current quality and year button. So user just click it, then the beginning date and ending field will be...

I have a query with code below: SELECT [Daily Sale Details Extended].[Sold Date], [Daily Sale Details Extended].[Selling Tool] AS Tool, Products.[Product Name] AS Product, [Daily Sale Details Extended].Quantity AS QTY, [Daily Sale Details Extended].[Extend Price] AS Price, [Daily Sale Details...

I have a cross tab query with the codes below: TRANSFORM Sum(OrdersDetail.Quantity) AS SumOfQuantity SELECT OrdersDetail.[Product Name] FROM OrdersDetail GROUP BY OrdersDetail.[Product Name] PIVOT OrdersDetail.Sold; Since some product never been sold, that's why it shows blank. What codes need...

I have a drop down field " Product" on the form. Once a product is selected, the fee will be auto populated based on the calculation that I created on the query. Now if the shipping fee is not free, the calculation will be the different. Therefore, I have created another calculation. And put...

Using the following codes to insert fields into another table. The codes works fine for all fields on the form, except for [Order ID], which is the autoNumber. CurrentDb.Execute "INSERT INTO [Inventory Transactions] ([Product ID], [Order ID])" _ & "VALUES (' " & Me.Product_ID & "', '" &...