Recent content by herbertioz

Ok, I see. Then back to work:) Thanks!

Hi, I have tried a long time to fix this issue, but I am stuck. Could someone help me out here ,please?:):banghead: I have a field called "Test" Id Test 1 2 2 4 3 6 Output from my query: 48 How can I get 48 as the result from the query? Its...

Thanks a lot, Plog! But I had to change it a bit to get it to work. The final code that works: =UCase(MonthName(Month(DateAdd("m";-1;Date()))))

I have this code: =UCase(MonthName(Month(Now()))) It prints out June, but I need it to print out May. How can I do that?

Thanks! That worked! The final working code: Private Sub Command40_Click() Dim rs As DAO.Recordset Set rs = CurrentDb.OpenRecordset("SELECT * FROM Numbers") Dim test As Integer test = 1 If Not (rs.EOF And rs.BOF) Then Do Until rs.EOF = True test = test * rs.Fields("Number")...

Private Sub Command40_Click() Dim rs As DAO.Recordset Dim test As Double Set rs = CurrentDb.OpenRecordset("SELECT * FROM Numbers") If Not (rs.EOF And rs.BOF) Then Do Until rs.EOF = True test = rs.Fields("Number") 'Move to the next record. Don't ever forget to do...

Ok, thanks,Pbaldy! I am going to write the function and add it here.

I try to multiply all records in a field in Access. For example: 2*2*3*3=36 ID Number 1 2 2 2 3 3 4 3 How can I do that with a query? is it supported?

I found out the solution and the solution was the following: SELECT Month, Sales, DSum("Sales","table1","ID <=" & [ID]) AS RunningSum FROM table1; Thanks Access Programmers:)

I am trying to make a query that give me an output of an aggregate percentage column, or running sum of percentage. Please see my example: Month Sales in % Running sum percentage Jan 5.03 % 5.03 % Feb 2.17 %...

Please see the attached excelsheet.

I have two tables, table 1 with these field: - ID (pk,auto) - Orders - Market - ProductLocalName Table 2: - ID(pk,auto) - Product - GlobalMarket - MarketArea - PlannedOrders My goal is to SUM the Orders in table 1 (local orders) and compare it with the field PlannedOrders in table 2 and get...

Sorry for that last post. You've solved it:) Now I got what I want. SELECT * FROM Motortable LEFT JOIN subInStock ON Motortable.Motors = subInStock.Motors WHERE (((subInStock.Motors Is Null)); Thanks for all help:)

I am not getting one motor, but all motors that is "Installed". I have multiple motors with the same name and someone is "In Stock" and some is "Installed". I want to get a list with only the motors which is "Installed" and have not any InStock if the motor has the same name.

Something like these: SELECT * FROM Motortable LEFT JOIN subInStock ON Motortable.Motors = subInStock.Motors WHERE (((subInStock.Motors Is Null));