My company is planning on moving from Peregrine's ServiceCenter to HP's Service Desk. I am responsible for reporting and have been asked to set up real-time reporting showing call spikes by call type based on 15, 30, and 60 minute intervals. I have never worked with Service Desk and wondered if...
I've had a period table added to the database. The dates are in DateTime format with time set as 12:00 AM. When I do a left join on the period table, I only get records from the second table showing records with Open_Time (a DateTime field) have the time as 12:00 AM. The DBA said I'd have to go...
If I'm not mistaken, you should be able to create a formula from that field using the IsDate () function to turn it into a date. I imagine the helpfiles have more detail on formatting, but I'm pretty sure that would work.
I'm thinking you could create a separate table with 2 fields...Line# and GroupDesc (sealing, grouting, locking). Create a query linking the two tables based on Line# containing all the necessary fields including GroupDesc and group on that field as desired. You can use the Make Table query to...
Here's were I reveal my ignorance...how? I have read only access to the database where I pull data from. I would need to create a table outside the database where the rest of the data is stored. Right? And what's a period table? I've had very little "official" training...it's been...
I've created a report that pulls numbers of tickets based on day and category. I have charts showing this data; however, if there were no tickets for that day for a particular category, the date is skipped on the chart. I need days without tickets to show as zero. I've tried using cross-tab...
The way it works in CR 8.0 is that you go to printer setup and select Adobe Distiller. Then when you want to create the .pdf file, just click print. It should launch distiller and create the .pdf file. Then you just go to file, save as and you're good to go.
If what you've tried thus far doesn't work, this might...
Assuming there a unique identifier field in each table (something that is different in each record)that you set as the primary key). You could then create an append query and it will append only the new records (will get an prompt...
Just a thought...have you tried importing the main spreadsheet into Access instead of linking to it. Then link to the spreadsheets containing the new information. Then use the append query to append the new data. You could then export the updated file to Excel. Not the quickest method, but I...
Just a though...have you tried importing the main spreadsheet into Access instead of linking to it. Then link to the spreadsheets containing the new information. Then use the append query to append the new data. You could then export the updated file to Excel. Not the quickest method, but I...
Well, I just had an epiphany...I created a new query combining all three tables. Orginally I thought I couldn't because the data would repeat 30 times for each of the category breakdowns due to the 30 days data in the 3rd table, which it did. However, I created a new report based on the new...
The reason for the sub-report is each report has different criteria. The main report is based on a query which is based off two tables. First table contains number of tickets, date, and day of week for each category breakdown for previous day. The subreport contains number of tickets, daily...
Access 2000: I've created a report that is grouped on a specific field (Category Breakdown). I created a separate report using the Chart wizard to show trended data based on a query (past 30 days data for each category breakdown), then imported it into the first report as a sub-report. I did not...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.