Search results

  1. J

    IIf return null values

    Sorry wayne here is all my sql SELECT ACMFTBL.ACMF_NUMBER AS ACC_NUMBER, ACMFTBL.ACMF_NAME AS ACC_NAME, ACMFTBL.ACMF_ADDRESS_1 AS ADDRESS1, ACMFTBL.ACMF_ADDRESS_2 AS ADDRESS2, ACMFTBL.ACMF_ADDRESS_3 AS ADDRESS3, ACMFTBL.ACMF_POST_CODE AS POSTCODE, ACMFTBL.ACMF_PHONE_NO AS PHONE_NO...
  2. J

    IIf return null values

    Wayne, what i am trying to say is if this check box is ticked return all accounts who use the account in multiple sites (which in this stupid database is a null value) otherwise if that box isnt ticked show accounts where the store number = the accounts store number which as you have said below...
  3. J

    IIf return null values

    I have a query I am creating where if a check box is ticked i want to return all null values of a specific field this code is the line I am having problems with ((ACMFTBL.ACMF_SYSC_NUMBER)=IIf([Forms]![frmACCSTATEMENTS]![chkSTORE]=0,[SYSCTBL].[SYSC_NUMBER],(ACMFTBL.ACMF_SYSC_NUMBER) Is...
  4. J

    Daily Account balance

    Doc_Man dont worry bout it mate thanks for your help found using the running total option on a textbox on the report works great jason
  5. J

    Daily Account balance

    Doc_Man I have written the below query with dsum but i get the same value on all dates What am i missing? SELECT qryACCDAILYTRX.ACCOUNT, DSum("TRXAMT","qryACCDAILYTRX", "ACCOUNT Between Forms![frmACCTRX]![txtACCFROM] and Forms![frmACCTRX]![txtACCTO] and ACOP_TRX_DATE Between...
  6. J

    Daily Account balance

    Hey guys I have a table I am trying to write a query for that will give me a closing balance for an account on each day. Now I have no control over the table and its fields as its a 3rd party database I am ok calculating the starting opening balance by just adding all sales and minusing all...
  7. J

    query's sql statement

    bob thanks for ur help again with this everything is good now :) except my dates are being stored in my query as u.s format even when i format them dd/mm/yyyy anyway to say force it to say which value is my day month year etc?
  8. J

    query's sql statement

    yeah sorry bob bit out of it today cell = 22 p = 1 Do Until p = 3 Set qdf = New ADODB.Recordset Set qdf.ActiveConnection = CurrentProject.Connection sqlp = "SELECT * FROM qryPERIOD" & p qdf.Open sqlp...
  9. J

    query's sql statement

    Bob that works great :) except only 2 things 1. how do i get spaces between fields i am returning as the result current looks like this. PERIOD 2BAR 27/01/20087/10/2008 and should look like this. PERIOD 2 BAR 2 01/07/2008 10/07/2008 the other is my code seems to be taking the record from...
  10. J

    query's sql statement

    Public Function excelquery(strsql As String, period As String, rptval As Integer) On Error GoTo excel_error Dim gobjExcel As Object Dim objws As Object Dim rng As Object Dim con As ADODB.Connection Dim rstdata As ADODB.Recordset Dim rstcount As ADODB.Recordset Dim fld As ADODB.field Dim...
  11. J

    query's sql statement

    ok sorry bout that one guys i have it almost done just the only thing i am getting is the first column in the query when i want all values returned the code is as follows cell = 22 p = 1 Do Until p = 10 Set qdf = New ADODB.Recordset...
  12. J

    query's sql statement

    ok guys i have it now set that i create a query for each period which stores the values i need. i was thinking the below code to send it to excel cell = 22 p = 1 Do Until p = 10 For Each qdf In db.QueryDefs If qdf.Name =...
  13. J

    query's sql statement

    ok guys im not sure if i should be posting this here or under queries so apologies in advance. i have a query that stores a series of days and values for those days that exports to excel as a graph and works well the only thing i would like to be able do is in some cells under the graph list...
  14. J

    Error 3075

    sorry guys i think i have posted this under wrong section can some1 move it to queries for me?
  15. J

    Error 3075

    oops sorry guys forgot the attachment
  16. J

    Error 3075

    Hi guys, i am getting the attached error when running a form but it only appears on some pcs not others. SELECT HTRXTBL.HTRX_TRX_DATE, AREATBL.AREA_DESC, CDate(Format([HTRXTBL].[HTRX_TIMESTAMP],"dd/mm/yy hh:nn")) AS TIME_DATESTAMP...
  17. J

    ODBC 3146 Error for Some Users

    Nevermind guys figured it out, it was reading as a string not a date used CDate() in it and works fine now thank u:)
  18. J

    ODBC 3146 Error for Some Users

    Ok got the actual error message as follows from the query i create ODBC-CALL FAILED ODBC Firebird Driver Firebird Conversion Error From string "29/07/2008" #-413 I know what the problem is, its the fact its formatting as dd/mm/yyyy where as firebird and this database need it formatted as...
  19. J

    Last Week/Month text box

    Hey guys I know i have seen this somewhere and i thought it was on here where i could depending on a choice from a combo box change the date value in a text box from today to last week or last month. Any ideas? Jason
  20. J

    Upgrade odbc for Windows Xp

    Bob sorry, what i mean is the odbc32*.dll versions in the \windows\system32 folder. I am just having an issue with some computers and not others and I am trying to rule out various things.
Back
Top Bottom