Search results

  1. A

    function help

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

    Query Condition

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

    Sorting/grouping

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

    Math, Adding two fields in a report

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

    Union

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

    Union queries

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

    Format a multy value field

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

    Compare value , and assign a value if not found in table

    In a new project i have the following which i cant get to compare properly SELECT [D 01 RM FR Reason Code Update].*, Left([Customer_Action_Req_d_Reason],InStr(1,[Customer_Action_Req_d_Reason],",")-1) AS Code1...
  9. A

    Replace squares on a multie value field.

    I have a field that has many records. in which there are squares instead of commas Is there query or command i can try and have them replaced.
  10. A

    Spaces in a multie value field.

    Afternoon, Im trying to runt he following module on in a query so that it will remove spaces from a field that has 3 sets of values. 063, 683,091 spaces could be 063, 683,091 063,683 ,091 063, 683, 091 Public Function RemoveSpace(ByVal strData As String) As String Dim intPosition As...
Back
Top Bottom