Search results

I have a query which displays all sold products total correctly, but the heading is the product code NOT the product name TRANSFORM Count(tblPayments.Product_ID) AS CountOfProduct_ID SELECT "Total Count" AS Remarks FROM tblScale INNER JOIN tblPayments ON (tblScale.AMOUNT =...

i have removed the tool bar with **** DoCmd.ShowToolbar "Ribbon", acToolbarNo" and 'Me.Caption = " " **** but it still shows can i remove this? Thank you ver much Sepp

I have a table (see below) which has field "Product_ID", ( numbers 1 to 7). I would like to create a query to give me in seven field the count of each product. I tried but failed. Thank you Sepp

I got the runtime settings correct, but my form still displays the FILE + search bar . how can i hide it? Many thanks Sepp

Good morning, i need to set a date depending on weekly, monthly or yearly. is this correct, ******************************************************** =IIf([Product_ID]="4",DateAdd("ww",1,[Order_Date]),IIf([Product_ID]="5",DateAdd("m",1,[Order_Date]),DateAdd("yyyy",1,[Order_Date])))...

Private Sub Product_ID_AfterUpdate() INSERT INTO tblPayments ([Product Value]) SELECT [AMOUNT] FROM tblScale WHERE tbl.Payments.[Product ID] = tblScale.[ID] End Sub Please help with this, i have not used Access for many years. how do i write this correctly? Many thanks Sepp