I have a database with information on customers and their
transactions.
The table with transactions has the following fields:
Customer ID , Transaction ID, Transaction Type, Transaction Amount,
Transaction Date
Each customer may have up to 6 transactions.
I'd need to create a table where each record is a customer and which
has these fields:
Customer ID , 1st Transaction - Transaction Type, 1st Transaction -
Transaction Date, 1st Transaction - Transaction Amount, 2nd
Transaction - transaction type and so on
I can create a summary of the amounts with a crosstab, but it would
not be sufficient as I need the specific details of each and every
transaction. Plus, "Transactio n type" is a text field.
Would you have any suggestions?
Thanks!
PS I use Access 2007
4  1688 
On Oct 10, 7:13 am, "myemail...@goo glemail.com"
<myemail...@goo glemail.comwrot e:
I have a database with information on customers and their
transactions.
The table with transactions has the following fields:
Customer ID , Transaction ID, Transaction Type, Transaction Amount,
Transaction Date
Each customer may have up to 6 transactions.
I'd need to create a table where each record is a customer and which
has these fields:
Customer ID , 1st Transaction - Transaction Type, 1st Transaction -
Transaction Date, 1st Transaction - Transaction Amount, 2nd
Transaction - transaction type and so on
I can create a summary of the amounts with a crosstab, but it would
not be sufficient as I need the specific details of each and every
transaction. Plus, "Transactio n type" is a text field.
Would you have any suggestions?
Thanks!
PS I use Access 2007
You have made several declarative statements and one question, "Would
you have any suggestions?. What is it that you want? To build the
table, or to create a report off of it? I can't say that I am happy
with your choice of mixing customer data with transaction data. This
seems like a really bad idea. They should be in separate tables.
You have made several declarative statements and one question, "Would
you have any suggestions?. What is it that you want? To build the
table, or to create a report off of it?
I need to combine the information as I described. Being a novice to
access, I have little clue as to what the best method might be (query,
report or else).
I can't say that I am happy
with your choice of mixing customer data with transaction data. This
seems like a really bad idea. They should be in separate tables.- Hide quoted text
They are separate tables and will stay as such. I do not wish to
change the structure of the whole database; I just need to combine the
information as described (customers and transactions) to run a very
specific analysis on a very specific subset of customers.
Sorry if the questions might seem very banal: I literally just got
started with Access! Thanks in advance!
On Oct 10, 10:47 am, "myemail...@goo glemail.com"
<myemail...@goo glemail.comwrot e:
You have made several declarative statements and one question, "Would
you have any suggestions?. What is it that you want? To build the
table, or to create a report off of it?
I need to combine the information as I described. Being a novice to
access, I have little clue as to what the best method might be (query,
report or else).
I can't say that I am happy
with your choice of mixing customer data with transaction data. This
seems like a really bad idea. They should be in separate tables.- Hide quoted text
They are separate tables and will stay as such. I do not wish to
change the structure of the whole database; I just need to combine the
information as described (customers and transactions) to run a very
specific analysis on a very specific subset of customers.
Sorry if the questions might seem very banal: I literally just got
started with Access! Thanks in advance!
It all depends on what your output will be; if you want a printed
report, then you will need to make a report. If you only want it to
display the combined data on the screen, then a query will do. A
report can also be made off of a query. If this is a one time thing
and you don't need to print it, then make a query in the query
builder. If you are going to use it more than once, then build some
code into a command button. Does this database have existing forms?
Do you want to add a button to one of them for this report? Do you
know any programming? If only I were psychic... ;-)
It all depends on what your output will be; if you want a printed
report, then you will need to make a report. If you only want it to
display the combined data on the screen, then a query will do.
The I guess a query will do, in my case.
A
report can also be made off of a query. If this is a one time thing
and you don't need to print it, then make a query in the query
builder. If you are going to use it more than once, then build some
code into a command button. Does this database have existing forms?
No, it doesn't at the moment
Do you want to add a button to one of them for this report? Do you
know any programming? If only I were psychic... ;-)-
I know VBA and Matlab programming, but I can't say I know any SQL
Thanks! This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Frnak McKenney |
last post by:
Back when computer dinosaurs roamed the earth and the precursors to
today's Internet were tiny flocks of TDMs living symbiotically with
the silicon giants, tracking access to data processing resources was
much simpler: you logged in with a userID and password, and when
you were done you ended your session by logging out (or occasionally
by being disconnected). Connection time was easy to measure, and it
made sense to both the customer...
|
by: Redd |
last post by:
The following is a technical report on a data modeling project
that was recently assigned to me by my professor. I post it
so that anyone else who is studying databases and data modeling
can have an example to go by with their study of databases.
I was assinged to come up with a data model, but I choose the
Autoparts sales and inventory management schema.
It you would like the SQL code to generate the schema or if
you would like the ERWin...
|
by: Will |
last post by:
On the subject of Data Warehouses, Data Cubes & OLAP….
I would like to speak frankly about Data Warehouses, Data Cubes and
OLAP (on-line analytical processing). Has it dawned on anyone else
that these buzz words were created by some geek who decided to take a
stab at marketing? Knowing that to the backwoods manager who knows
little of technology that new innovative names for old concepts would
help to sale their products.
I mean...
|
by: Alexander Pope |
last post by:
Is there some some standard for this type of database issue?
We have an internet application. db2 aix v8.1. was5.0.
Our customers want to be able to "upload" or "import" data into our
database.
for example, the customer would have the info in a standardized format
such as a spreadsheet or text file.
the customer would submit the file at their convenience within the
appication. Somehow the data would eventually imported into the...
|
by: dan graziano |
last post by:
I have a very large data set where I have to do considerable regrouping
of values and would like to know how you would suggest doing the
following regrouping?
The structure of the data set is the following (heading fields in first
row and columns separated by commas):
country, year, company, department, expenses (dollars)
USA, 2002, Pepsi, marketing,1004
France, 2001, Pepsi, marketing,300
| | |
by: TheCoder |
last post by:
I am making a D-base with web conectivity for my class project. I have
everything working but the subit button sends the data to the correct
fields but afterwards it wants to reproduce new blank text boxes how do
I stop this and how would I code it to redirect to a thank you page.
All with out the help of a web server this has to br ran from the
desktop and with in IE with a local directory. Pleas help I am stuck.
here is the code!
...
|
by: sampalmer21 |
last post by:
Hi,
I want to join two tables together and only select the rows that don't have the same customer first name and last name (see my code below). When I run my code with the DISTINCT keyword, it still returns me all of the rows probably because it requires each column to be the same in order to find distinct rows, but I want the rows just as long as the customer first and last names are different from other customers:
use AppDb
SELECT...
|
by: erikcw |
last post by:
Hi,
I'm working on a web application where each user will be creating
several "projects" in there account, each with 1,000-50,000 objects.
Each object will consist of a unique name, an id, and some meta data.
The number of objects will grow and shrink as the user works with
their project.
I'm trying to decided whether to store the objects in the database
|
by: giraffeboy |
last post by:
Hi there,
I'm having a problem with the Python db api, using MySQL.
I've written a program with a GUI using wxPython, the GUI is contained
in main.py which imports another module - reports.py. There are
several reports that are selected using the gui, and each report is a
class in the file reports.py. These classes contain a method which is
passed data as arguments and produces a report, writing HTML to a file
and using matplotlib to...
|
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: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
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: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| | |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
