-
Need help with a query
Hi, I am not an expert, so please bear with me. I am trying to do a query and do not find the solution but I am pretty sure that there is a solution.
So here is what I want to do: based on a table, I have the follwing query
Periode (exemple: March2017)
Client (exemple: Dummy)
Amount (exemple USD 1300)
Eventhough there are only 3 fields, there are hundreds of data (varios periods, lots of different clients and multiples amounts per client, period etc).
Now, I want to make a new query in oder to get the follwing summary:
I want to make a list which shows me for a certain period, let's say "March2017", a certain client (say Dummy), how much business he did (sum of Amounts).
This should look like this:
Client Jan2017 Feb2017 March2017 April2017 .................Dec2017
Dummy 500 30000 45000 150 301
Yummud 431 374 45 61 765
Mmudy 307 156 37 21 17
etc.
How can I do that?
Tks for the help.
-
make a query, Q1, to pull the data in the date range you want.
then use the query wizard and make a CROSSTAB query, using Q1.
it will ask you to pick the row field, the column field, and the value field.
-
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules