Recent content by andrewvranjes

thanks! thanks! thats works. now how do i link this query back to my original database? its name is workbench. it lives on a sql server, 192.168.10.13. we use access all the time at work. do you offer some sort of business charageable fixes ? please advise

thanks, didnt work again, but close! Hi Jon, thanks for that. it didnt work, but at least i can see the value in trying things other ways. with the date()-1 it selects no records. i increased the date() and it selects a few records, but not in the time range! i will attach the file if you...

it didtnt work Hi Jon, thanks for replying. no it didnt work. it accepts that syntax but selects no records. the time field is seperate from the date field, so i have tried some variations of >date()-1 in the date field and >time()-900, but it also selctes no records. i am thinking of...

Hello! this forum has helped me big time. now i have another quesiton. i want to run a report that selects all jobs from 5pm to 8am. I need to run this report at 8.01am to get all data from the previous night. I am resonably comfortable with the date functions but time queries elude me. i...

ah! looks easy now! ah! looks easy now cheers trabis , i will give this a go, it looks easy once you put in sql like that. by the way, i have not been able to export the ouputted data as text, normally i just go to file->export-> but its greyed out, any reason why its greyec out this time...

cheers trabis , i will give this a go, it looks easy once you put in sql like that. by the way, i have not been able to export the ouputted data as text, normally i just go to file->export-> but its greyed out, any reason why its greyec out this time? thanks again mate! so whats the weather...

travis! here it is hi travis, so what i understand is that i should attach your sql code to the end of my sql for this query, here is my sql code SELECT Companies.CompanyName AS SITE, LogHeader.LogDate AS [CALL DATE], LogHeader.LogHeaderID AS LOGNO, Format([LogTime],'hh:nn:ss') AS [CALL...

still cant make it work hi guys, im still not fillowing you, i put the expression into the last field in my query, "CHR(13) & CHR(10)" it just processed and displayed as usual, am i doing something wrong? cheers mates!

i dont follow you ? thanks for the info, but i still dont understand. basically i have a query that outputs data. i would like to format it to have a blank row between each row of data it outputs, can this be done? where is the debugger window? thanks mate

hi there! does anyone know how to force a blank line in between rows in data outputted by a query ? thanks !

hi fellow accessers! can anyone point me in the right direction on this issue. I have a query which needs to be run every hour during business hours. I have setup a scheduler to run this. The query has a marco that emails the query output to the call centre at my work. Which is exactly...

macro for emailling a outputted query Hi twin/ fellow accesser's if you have the time, can you point me in the right direction on this issue. I have a query which needs to be run every hour during business hours. I have setup a scheduler to run this. The query has a marco that emails the...

hi jon, cheers mate! the query i used was named hose query, so i renamed it in your sql. i also put it in square brackets bcos it has a space in the name. thanks again jon! kind regards, Andrew Vranjes

im a idiot hi jon, i understand what your sql does, but i dont understand where i should run it from. SELECT [Service Type Fault], Count(*) as NumOfFaults FROM Query3 GROUP BY [Service Type Fault] ORDER BY Count(*) DESC should i copy/paste into my original query? i trieed this to no...

the select statement sorry for not being precise, i would like to transfer a select query, not the data, but the actual query from my work computer to my home computer. any ideas? Andrew