Search results

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

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

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

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

hi there! i have to say this is the best site! i have have gained excellent knowledge in the past month. i have another problem though, i have a query which displays the common fualts for BP and i need to total it by fault, and display them in order of most common to least common. i have a...

hi ! i would like ot know if anyone knows how to save/store/transfer queries from one computer ot another? Andrew

guys! i am having trouble displaying SiteID field. i have only modified your sql code by adding SiteID into it and taking out JobCode......... SELECT CompanyName, JobCode, Count(*) as NumOfRecords FROM [BP Hose query] GROUP BY CompanyName, JobCode SELECT CompanyName, SiteID, Count(*) as...

hi there! can anyone help me please? i have 5 queries that total up the numebr of records in each. now i want to display this data. i have been using a cross tab query to do this but i am getting a error message! andrew

Hi ! i am an access newbie. I have just purchased the Access 2002 Inside Out book, by Helen Feddema and i have found it to be very useful. I am currently looking for a syntax list, for lack of a better description. My job requires me to do monthly queries and reports and it is taking me along...