I can't do it in Crystal Repots either without making a formula for each field so I thought about using 'copy an existing table structure wo/the data' (like to make a new table and append records to eliminate duplicates) to an increased field element table but that did not work even adding a qry...
I just want to take a random number of rows of patient id's containing lab data and as the qry reads the rows, post the lab data from each row into one single row into a new table.
It's the easiest thing that always causes the most exhasperation!
3 8446 PEB 1,418
Recognized Expert Top Contributor
Hi,
There is a way to do it... :)
You need to create a complementary table in which you insert the column names of your table with data... I suppose that in your Destination row table will be a field tha describes what kind information is it...
So when the complementary table is ready you create an Append query
based on the complementary table and your source table... You don't make a join btwn them!
Int the field description you put the field from the complementary table...
For the field with the information is a bit more difficult...
For it you need for the function Switch, the ID of the respective record and function like dlookup and all this in combination like:
Information: Switch([Description]="Field1", Dlookup("Field1 ","Mytable","ID ="+str([ID])),[Description]="Field2", Dlookup("Field2 ","Mytable","ID ="+str([ID])),.....,[Description]="Fieldn", Dlookup("Fieldn ","Mytable","ID ="+str([ID])))
So this is all!
:)
Thank you, this will make my life quite a bit easier, I do crystal reporting and it's pretty difficult in that realm, appreciate it !
Hi,
There is a way to do it... :)
You need to create a complementary table in which you insert the column names of your table with data... I suppose that in your Destination row table will be a field tha describes what kind information is it...
So when the complementary table is ready you create an Append query
based on the complementary table and your source table... You don't make a join btwn them!
Int the field description you put the field from the complementary table...
For the field with the information is a bit more difficult...
For it you need for the function Switch, the ID of the respective record and function like dlookup and all this in combination like:
Information: Switch([Description]="Field1", Dlookup("Field1 ","Mytable","ID ="+str([ID])),[Description]="Field2", Dlookup("Field2 ","Mytable","ID ="+str([ID])),.....,[Description]="Fieldn", Dlookup("Fieldn ","Mytable","ID ="+str([ID])))
So this is all!
:)
Hello, I am working on converting columns to rows in access.
I have three columns in a query, applican'ts first name, applicant's last name, and manager's name. I need to make a query such that applicant first name, applicant last name columns remain as the 1st and 2nd columns of the query, but managers names will appear as a row so that each manager can writer their decision reagarding each applicant.
Could you help me with this? I don't know any coding.
I appreciate your help.
Sign in to post your reply or Sign up for a free account.
Similar topics |
by: JL |
last post by:
Hi there
I have a database with entries like the following:
Id, Name, Goals_season, Goals_total
----------------------------------------
5, John, 5, 23
6, Mike, 2, 14
7, Joe, 10, 34
Every season we have to reset the "Goals_season" column to the default value
|
by: Lauren Quantrell |
last post by:
I have never written a trigger before and now am seeing the light. Is
there a way to write a trigger so that if a user changes any column in
a single row on one table then the trigger will write the value of
this (these) rows to a second table. I don't want the unchanged
columns, just the changed columns (with column names...)
Thanks,
lq
|
by: Fabio |
last post by:
Hello,
is there any quite easy solution for the problem of transposing the rows
into the columns? I have the following table with some data in it:
dealer date 09.00 10.00 11.00 12.00 13.00 14.00
-----------------------------------------------------------------
1 2004-10-01 1/1 2/3 3/3 3/4 4/5 ...
|
by: Paul |
last post by:
Hi
I have a table that currently has 466 columns and about 700,000
records. Adding a new DEFAULT column to this table takes a long time.
It it a lot faster to recreate the table with the new columns and then
copy all of the data across.
As far as I am aware when you add a DEFAULT column the following
happens:
|
by: VA |
last post by:
There are a lot of excellent drag-n-drop Javascript libraries available
out there
http://script.aculo.us/
http://www.walterzorn.com/dragdrop/dragdrop_e.htm
http://www.youngpup.net/2001/domdrag/tutorial
http://tool-man.org/examples/sorting.html
Yet, I am having a hard time finding a good demo of re-ordering HTML
table columns by drag and...
| |
by: Amber |
last post by:
Stored procedures are faster and more efficient than in-line SQL
statements. In this article we will look at two SQL Server stored
procedures; one using an input parameter and one not, and see how to
call them from an ASP.Net page
Every modern database system has a stored procedure language. SQL
Server is no different and has a relatively...
|
by: Erik Cruz |
last post by:
Hi.
I have a repeater control bound to an ArrayList. When displaying the data, I
need to show 3 columns per row, each column being one entry of my ArrayList,
but the repeater understands that each record is a new line. Using
ItemTemplate and AlternateItemTemplate I could display two columns but I
need another one. How can I display records...
|
by: a |
last post by:
Hey gang!
I have a specific problem, but a general answer may help. I am building a
web app which will display multiple UserControls on the screen. I want to
put them in a table that is X Columns by however many rows it takes to
complete the list.
I essentially need to add dim a new row, then a new cell, and continue
adding cells to...
|
by: Martin Joergensen |
last post by:
Hi,
I have some files which has the following content:
0 0 0 0 0 0
0 1 1 1 1 0
0 1 1 1 1 0
0 1 1 1 1 0
0 1 1 1 1 0
0 0 0 0 0 0
|
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...
|
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. ...
| |
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...
|
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...
|
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...
|
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...
|
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...
|
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...
| |
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| |