Search results

Ok guys what im after is if this is even possible and how would be the best i should go about doing the following. What i am trying to do is I have a query that will have a datediff field as well as a up to 4 total values so its qryCOMPARISON: DateDiff, Amount1, Amount2, Amount3, Amount4 i...

AJ thanks that i am fine with it is more if i need to reference the same subform from different forms with the same query that i am having the problem

aj that is basically what i am saying. as for the subform part i posted a question on subform references on the forms thread but no1 got back to me what my question was was how do i reference the same subform in various forms?

giovi did u ever get this to work cause i am trying to do the same?

hey guys i have a query where i need to say if txtPLUFROM is null select all records but if it isnt select all records between txtPLUFROMand txtPLUTO my theory on it was as follows IIf((Nz([Forms]![subfrmPLUFILTERS]![txtPLUFROM],0)=0),<>0,(>=[Forms]![subfrmPLUFILTERS]![txtPLUFROM] And...

hey everyone now i have done a few hours of searching on here first and i cant seem to find any1 with the same problem i am creating forms in access 2007 i have a subform with cascading combo boxes that i wish to use on multiple main forms as filters on reports. I have been able to get this to...

namliam i could just kiss u :) lol well if you are a good looking girl i could:) thanks mate that worked perfectly i am so grateful to everyone on here for there help with this :)

gemma sorry about my explanation before what i need to is import the data below H, 14, 26, 14, 22, 30, 03, 2008, 0, P, 1 D, 1 C, 1, C, 99, P, 1 I, 10462, 1, 7.90, I, 10463, 1, 8.90, C, 1, P, 2 I, 10462, 1, 7.90, I, 10463, 1, 8.90, C, 99, , P, 1 I, 10460, 1, 0.60, P, 3 I, 10471, 1, 16.90, P, 1...

Ok another questions guys sorry bout all the questions but have the record set case statement working great except for one factor i need to be able to merge a couple of rows into one row in another table Select Case Rs!Field1 Case "H" RsSales.AddNew ' Start a new record...

sorry namliam was late out night here when i read that msg bit tired and wasnt thinking straight

gemma and niam i do import to a staging table first "tblajltemp" then an running the recordset code from that table, gemma in respone to ur msg i def DONT want to run each H first for that exact reason was just making sure it wouldnt which u later confirmed it may not always do it in the right...

namliam thanks for your help with this just a question on using if statements for what i want to do. Since i have multiple records in my table in the following order or close to. H D C P I I I T T that gets repeated for each sale will it go through each if statement first or will it do all the...

namliam thanks mate i have made a start to this just getting a problem where i am in a continuous loop on my first part of the code any ideas? Dim DB As DAO.Database Dim Rs As DAO.Recordset Dim qdf As DAO.QueryDef Dim tbl As String Dim strSQL As String tbl = "tblAJLTEMP" Set DB = CurrentDb...

hey guys what i have is atm is a sgl table that i import a csv file into call tblAJLTEMP which all works fine i have even managed to import the first row which is a sales header into a table and convert the multiple date fields into 1 etc my problem lies with the rest of the data. basically the...

neil got it thanks mate SELECT DISTINCT a.HTRX_REF_NO, a.HTRX_REC_TYPE, a.HTRX_TRX_DATE, Format([a].[HTRX_TIMESTAMP],"dd/mm/yy hh:nn") AS TIME_DATESTAMP, AREATBL.AREA_DESC, a.HTRX_AREA_NUMBER FROM AREATBL INNER JOIN htrxtbl AS a ON AREATBL.AREA_NUMBER = a.HTRX_AREA_NUMBER WHERE...

hey guys im not even sure if i have the heading right for this one. I have a table example data attached, what i would like to do is return all transfers from that table where all the item numbers in a batch dont equal each other i.e if you subtract them all in a batch it doesnt = 0 i have...

hey guys nevermind figured it out have to use CInt on the command :)

hey guys i have the following query but the greater than part isn't working it is still showing all records SELECT AREATBL.AREA_DESC AS AREA, IDEPTBL.IDEP_DESC AS DEPARTMENT, ITEMTBL.ITEM_DESC AS ITEM, ITMATBL.ITMA_PRICE_1 AS RRP...

thanks mate much easier and simpler than what i had :)

so pbaldy something along the lines of Format(timeStamp,"dd/mm/yy:hh:mm:)?