Search results

Many thanks!!! :) i can finally see a calculation being done, When i add this to the query test: YTDINDBOARDED() Every line has the same value. its adding the rst1(49) and rst2(72) but only the first set of values. so every 18 members in my db have the same calculation now. so is it possible...

so change the boarded to the function name? Function YTDINDBOARDED() Dim db As DAO.Database Dim rst1 As DAO.Recordset Dim rst2 As DAO.Recordset Set db = CurrentDb() Set rst1 = db.OpenRecordset("SELECT Ind_Bact_Act FROM Sales_ReportResult") Set rst2 = db.OpenRecordset("SELECT Ind_Bact_Act...

I have the following code, which is not working for me, What im trying to do is, retreive values from two tables, which are identical. The reason why im doing this is because each table represents a months worth of data which is given to me at the begining of each month, Normalization is not...

Or if not that statment, then somehow add to the express if blank then assign 999

I currently have the following expresison in a query Rcode: Nz(DLookUp("Trans_Code","[Fee Reversal Transaction Codes]","Trans_Code='" &...

I have a join query in which i need a little bit of help :) what im trying display the content in groups Example the table is split into 4 fields Name Code Amount Manager BOB1 039 100 Dave BOB2 099 100 Ken BOB3 066 100 Barbie BOB4 039...

I might have fixed it, There was a problem with a table, and my query :) i guess i have to hit the books harder and see where i messed up

Sorry Yes i did :) i used the nz function is that similar?

like the first circle shows 81.20 but the space is empty where the formula, i wanted it to show the 81.20 because there was nothing in txtother for that one entry.

the picture shows figures in invalid but they dont showup in the txtbox i created with the formula to add both fields

They both contain values but not all the time. txtother has maybe 4 entries with numbers across the report. what i want is txtother to be added to the txtinvalid field

Good Morning, Im trying to do a calculation on a report, im using two fieldnames from controls, as follows =[txtother]+[txtinvalid] The thing is it calculates it sometimes, but does skips it as well. i have attached a picture of what i see

Wicked ! :)

Im having a big problem with a union, I thought all was well, until i noticed the amount of entires does not match, SELECT [D-Report-3-Code1-Final].[Created_By], [D-Report-3-Code1-Final].[Rcode], [D-Report-3-Code1-Final].[Amount] FROM [D-Report-3-Code1-Final] Gives me 972...

SELECT D-Report-3-Code1-Final.Created_By, D-Report-3-Code1-Final.Rcode, D-Report-3-Code1-Final.Amount FROM D-Report-3-Code1-Final UNION SELECT D-Report-3-Code2-Final.Created_By, D-Report-3-Code2-Final.Rcode, D-Report-3-Code2-Final.Amount FROM...

im trying this SELECT D-Report-3-Code1-Final.Created_By, D-Report-3-Code1-Final.Rcode, D-Report-3-Code1-Final.Amount, FROM D-Report-3-Code1-Final UNION SELECT D-Report-3-Code2-Final.Created_By, D-Report-3-Code2-Final.Rcode, D-Report-3-Code2-Final.Amount, FROM D-Report-3-Code2-Final UNION...

Possible to union select 3 queries? All data D-report3 D-report3-Code2-Final d-report3-code3-f Thanks for your time

I have the following in a query which seperates a multy value field. SELECT D-Report.*, Left([Customer_Action_Req_d_Reason],InStr(1,[Customer_Action_Req_d_Reason],",")-1) AS Code1...

That worked, thankS!!

Yes to replace something in a field by forcing. Public Function RemoveSquares(ByVal strData As String) As String RemoveSquares = Replace(strData, Chr(10), ",") End Function