Search results

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

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

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

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

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

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

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?

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

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

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

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

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 =...

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

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

oops sorry guys forgot the attachment

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

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

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

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

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.