I have a problem which needs a sloution, I have a database of a phone bill which contains all calls made from 100 different branches, this is split down to if the call was local "L", national "N" and local rate "LR", obviously each branch makes a number of each type of call. In total there is nearlly 60,000 calls.
What I need to do is seperate all the branches, then count how many local calls each of them made, then output this to a spreadsheet.
The output I envisage would look like this (in the spreadsheet)
BRANCH | NUMBER OF CALLS |
001
002
.
.
.
etc
the branch number is pre-defined, so both these fields are contained within the data.
4  1700  NeoPa 32,569
Recognized Expert Moderator MVP
This question was posted in the Access Articles section by mistake.
I have moved it into the Access Forum section instead.
MODERATOR.
NeoPa 32,569
Recognized Expert Moderator MVP
Please include the MetaData for your table. Here is an example of how to post table MetaData : Table Name=tblStudent - Field; Type; IndexInfo
-
StudentID; AutoNumber; PK
-
Family; String; FK
-
Name; String
-
University; String; FK
-
Mark; Numeric
-
LastAttendance; Date/Time
This will make it easier to provide the help you require.
Sorry I was a little vague, here is further information about the problem. Table Name = TblCallRecords
the fields I need to take out of the table above are: - ChargeGroup; String
-
Date; Date/Time
-
DistBand; String
ChargeGroup is individual branches approx 100
Date is the date of the call
DistBand is either "L", "LR", "N", "fm1", "fm2", "fm3", "fm4" - this is the main field as I need all the "L"s count how many per day per branch, so if ChargeGroup = Edinburgh count all the "L"s made per day, then output these results into Access as a new table, which in turn can be exported to Excel.
I would like to do this via VB in Access, by just clicking a button.
Cheers
NeoPa 32,569
Recognized Expert Moderator MVP
You can start with a query as below. No-one's going to do your whole project for you, but we may be able to help you along the way if you make the effort to try yourself first. That way, we can fill in the gaps. - SELECT [ChargeGroup],[Date],Count([DistBand]) As Calls
-
FROM [TblCallRecords]
-
GROUP BY [ChargeGroup],[Date]
Sign in to post your reply or Sign up for a free account.
Similar topics | |
by: Catherine Jo Morgan |
last post by:
Some columns in the excel contact info spreadsheet correspond exactly with
the new database fields. Three columns contain a mishmash of info that will
need to be entered manually in the correct database fields. Maybe I could
make a form to use for this, to use to hold and view the information from
the three excel fields, as well as to copy and paste the info into the
correct database field? Or is there a better way?
I'm still designing...
|
by: JM |
last post by:
Hi
I have created a Windows Form that takes input. When the Run button is
pressed the form is disabled and the code checks some files and inputs the
data into an Excel worksheet (that is hidden so that I cannot watch as it
gets filled up). When it is done it saves the Excel file.
I find that if I go into another program while it's trying to work on the
Excel spreadsheet that not all of the data appears (missing data!). If I
click...
|
by: Scott M. Lyon |
last post by:
I've just discovered a bug in some code I wrote a little while ago, and I
need you guys' help to fix it.
My program imports data from a standard Excel Spreadsheet (just with
specific column headers). I used ODBC in my VB.NET program to read that
spreadsheet into a dataset, to make it easy to manipulate. The code I use to
read it is as the bottom of this posting.
|
by: Grip |
last post by:
Hi,
I have gone throught the group and Microsoft's online help and have
seen many suggestions but I am still seeking clarity:
1. I have an excel spreadsheet. Column A contains text that may be
greater than 255 characters.
2. I have an access database. I link (not import) to the contents of
the excel spreadsheet. In the design view in access, Column A has the
data type "memo".
|
by: ssrirao |
last post by:
There is an Excel Spreadsheet containing data, residing in an internet site.
It’s very easy to Import data from a local Excel Spreadsheet into SQL Server Database Table using DTS.
But in my case the Excel spreadsheet resides an internet site which has a static name (Example xyz.xls) but varying data inside it.
The spreadsheet contains three columns a, b, c and data below it.
Only data get updated weekly
So basically I have to automate...
| | |
by: Steve Kershaw |
last post by:
Hi,
I'm working on a project in which I have a Gridview that has data.
That Gridview data must be then exported to an Excel spreadsheet.
I have successfully displayed the Excel spreadsheet and fill it with
data using the Range.InvokeMember(...) method:
Range range2 = worksheet.get_Range("A1", "L1");
Object args2 = new Object;
|
by: Merlin1857 |
last post by:
Its great producing data for users to look at in your web pages and generally that is sufficient for their needs but sometimes you may want to supply your user with the data in a form they can actually do something more with. This code shows you how to display data from your database and then how to give that data to the user in the form of a useable Excel spreadsheet which they can then take away and play with themselves. The way I have shown...
|
by: is49460 |
last post by:
Good afternoon!
I use transfer spreadsheet function the export data from one of the table into the excel spreat sheet. I use the following code:
DoCmd.TransferSpreadsheet acExport, 8, "qry Rejected Items", Path & "Output Files\Rejected Items.xls", True, "NewData"
Please note that the output should be placed in the "NewData" tab.
In the same excel file the output was made to, i have function that is excecuted on open:
Sub Auto_Open()
|
by: chuch0117291 |
last post by:
Hi, i have a form with the main details of a vendor and and contract description and a budget reference(PK). Within this form, i have a sub form which includes cost details for that specific vendor but also has the same budget reference hence the link. I would like to create a command button to be able to export the data from the main form to an excel spreadsheet and the data from the sub form to excel spreadsheet tab2 from the click of a...
|
by: gjones |
last post by:
I have an Oracle Forms application and I want to populate an Excel spreadsheet with some data from the application.
I am using the DDE.Poke command to transfer data into the spredsheet and that is fine, but there are some merged cells on the spreadsheet that will not allow data to be transferred to using the DDE.Poke command, DDE.POKE(docid, 'R9C8',tmpdateperiod, DDE.CF_TEXT, 1000);
Is there a way that I can populate merged cells in Excel...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| | |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
| | |
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
