Search results

Sorry, I may not have explained the my situation and the data properly. A record that is being imported has many fields / columns, but the ones that I am interested in are the following: Phone Number Start Time Duration 9871234567 8:43 3:00 9871234567...

I have a monthly report that I receive in Excel. It is a cellular phone bill that contains a list of every call, text and data activity on phones. I have imported this into Access and want to create a query where I can get a list of phone numbers with the number of minutes that they have been on...

Thank you for the response. I tried the code below, modifying it to my specifications and it worked a bit. It produced an email for each record so if Office A had 7 printers and Office B had 5 printers, it created 12 email messages s, each with a pdf attachment showing all 12 printers. What...

We have a database that contains our branch offices their printing devices and usage. An example of the data would be: Office , Printer Model, Serial Number, Mono Count, Colour Count. City A X123 1234 35 156 City A X123...

Sorry, I forgot to add that I would like to do the count of calls by month. So basically Employee A received or made 7 calls during the time of midnight to 5:30 am on the July 16 invoice, Employee B received or made 17 calls during the time of midnight to 5:30 am on the July 16 invoice, etc.

There is no StartTime or StopTime in the table. There are 6,012 records that is like below. The data is organized as such: Mobile Nbr Name Invc Date Time 9051234567 John 16/7/2015 0:19 9051230987 Bernie 16/7/2015 0:22 9051234567 John...

This is my first post requesting help so I hope that I get it right! I have a table that contains fields for cellular phone usage. The important fields for this question are Invoice Date, Name and Time (time that a call was made or received in a hh:mm format). I want to be able to count the...

Hello everyone.