Hi there, I got a little data transformation problem:
I have got a source table:
ID 1 2 3
1 x y z
2 xx yy zz
That I wanna transform to the following format:
ID ID2 Comment
1 1 x
1 2 y
1 3 z
2 1 xx
etc...
The problem is, that I need a routine that takes the column names of table 1 and uses them as values in table 2. So basically, every column of table 1 (1,2,3, etc.) should become a new data record in table 2.
I need to replicate an existing report that has a number of 3 columns across the page and has 35-40 rows down the page...it's like a table in Word or a spreadsheet in Excel. I need to print the column and row lines.
Is there a simple way to include these in the report other than me drawing each and every line?
How can I change the Vertical Scroll bar color? I want to keep it for using, but the color is always grey color. How can I change the color of the scroll bar?
I have a Volunteer Database that has teams. There is only one team leader but some of the teams have two or three assistants. Currently I have a query that lists all the assistants for each team vertically.What I want to do is list the Assistants horizontally under headings like Assistant 1; Assistant 2; and Assistant 3 for each team on one line.
How to Creating a Three-Level Navigation Form, First and second level must be in horizontal orientation, third level desirable be to vertical orientation and dependent of level 2.
I have a form which I would like to enable scrollbars both horizontally and vertically (the main reason being, the application is designed for users with large / wide screens but may at some point be required on smaller screens)
Currently I have the scrollbars switched off and the form maximises but everything goes to pot if I resize the window. I'd like to add the scrollbars so if a user wants to resize the window to, say, half the screen, they can still scroll across to the 'hidden' parts of the form.
The problem with this is, if the form is maximised - or at least large enough to show the entire form - the area of the screen where the horizontal scrollbar resides is white (whereas the background colour of the form is a pale green) Which is quite unsightly.
I know I can remove the problem by removing the horizontal scrollbar and the navigation bar (which is already gone!) but then I can't scroll?
Is it possible to have a horizontal scrollbar but not have that white space at the bottom when the scrollbar is not required?
(Doesn't appear to be a problem with the vertical scrollbar?...)
And I'd like to convert it to this: Member_IDDiagnosis - 1Diagnosis - 2Diagnosis - 3Diagnosis - 4 10000 HypothermiaFrost Bite 10001 Fatigue DehydrationExhaustion 99999 Exhaustion Hypothermia
The columns don't line up well but I am looking for each diagnosis to move into one of the 4 columns, depending on whether it is the first, second, third or fourth diagnosis associated with the member.
I have a problem with my access base and i would like your advice. I have two tables in my base, in the first “Data” I have a field which name “Mtt”. I would like to transform the field name “Mtt” by the name of month preceding (if i‘am in August, I would like July like in the base DataAfter) but I would like make it by the code but i don’t know how can i do this ?. Is it possible to use the function Now().
In the second Table “Database” I have a lot of field and I would like insert a new field each month. I would like take the data “July” in the base “DataAfter” and insert this new field in the table DataBase. I would to do this operation each month. How can I do this?.
May i reach following function by Grid Query design or by SQL
Original: ============================================== Factory 1-----------Product A Factory 1-----------Product B Factory 1-----------Product C Factory 1-----------Product D
Factory 2-----------Product D Factory 2-----------Product E Factory 2-----------Product F
Factory 3-----------Product D Factory 3-----------Product E Factory 3-----------Product F
Result: ============================================== Factory 1-----------Product A,Product B,Product C,Product D Factory 2-----------Product D,Product E,Product F Factory 3-----------Product D,Product E,Product F
I'm trying to import an XML file into my access database using an XSL Transform (I only need certain bits of data), however when I import the tables and field names come through fine now but the only values that come through are the last values listed in the XML file... for instance when i import high there would be 10 high values but only the last one comes through.I would obviously like the "Day" field to be a date/time field in access, and the high and low to be a number field in access... but this is back-burner to solving the real issue listed up top.This is my XSL file:
Code:
<?xml version="1.0" encoding="ISO-8859-1"?> <xsl:stylesheet version="1.0" xmlns:xsl="Transform Link (I don't have 10 posts yet and can't post links)"> <xsl:template match="/"> <Weather> <xsl:for-each select="response/forecast/simpleforecast/forecastdays/forecastday">
I'm having difficulty getting my import to work... when i call on the original XML file I get too many tables... when i call on the XML file using the transform function of Access with the XSL file it gives me only two tables "body" and "tr". Body contains the value "Weather" and tr contains the value "Day".
Import the day as month/day/year into a field "Day" in access table "WeatherSFCAL"
Import the Fahrenheit temp from the high section into the field "High" in access table "WeatherSFCAL"
Import the Fahrenheit temp from the low section into the field "Low" in access table "WeatherSFCAL"
I'm trying to construct an SQL crosstab query that will output data like the picture I've attached in the .zip file.
The four variables from the data table would be [Client Accounting].[Marketer] (the left vertical column), [Client Accounting].[Closing Date] (the higher level horizontal column grouped by month), [Client Accounting].[Write Off] and [Client Accounting].[Refund] (the lower level horizontal columns as sums)
The totals column at the bottom and the two vertical columns at the right would be made in the report and wouldn't need to be in the query.
This is what I have so far but I don't know how to add a second TRANSFORM statement to be included and grouped by month!
Code: TRANSFORM Sum([Client Accounting].[Refund]) AS SumOfRefund SELECT [Client Accounting].[Marketer] FROM [Client Accounting] GROUP BY [Client Accounting].[Marketer] PIVOT Format([Closing Date],"mmm") In ("Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec");
I have a small issue where I do have names written in UPPER CASE, I would like to transform them in Capitalized (each word), I understand that I cannot use the same function as in excel (PROPER) but something like StrConv, but as I do have a ‘comma’ in between the names I have something like that
How do you add a horizontal scroll bar to a list box? I know that access will add a horizontal scroll bar when neccessary, but it will not add one to my list box. Is there a way to manually add one?
I am having a problem with the formatting of a report. My boss would like for the report to show (grouped by employee name) a horizontal list like below and update itself.
Each training class has a category in the table showing which model(s) the training is. For OJT I got it to count up the tasks and tasks completed in each model and calculate the percentage. I can easily get it to show vertical for each employee. I cannot get it to show like above. I tried using IIF statements to pull the hours and OJT by model aircraft. If I try to put it in the detail section it shows vertical and if I put it in the group of employee name it only returns one record (I assume its still trying to show vertical). The only way I could think of to get it to show properly was a crosstab query but its my understanding those are for archival purposes or for a snapshot and do not update. This report will need to update as things are entered.
I tried searching, to no avail. I've attached pics to represent my issue a bit clearer. I have a form that I want to be my switchboard, but my clients all have different resolutions, and this is where I run into the problem. I want the switchboard to not only be maximized, but appear maximized.
Here is the design view: Linkage (http://www.martinaustin.net/images/issue_design_view.jpg) Here is the form view: Linkage (http://www.martinaustin.net/images/issue_form_view.jpg)
I want the date and bottom line to always be at the bottom. This works fine by simply using form headers and footers. The issue is that the Admin button will appear near the center (vertically) when viewed on a computer with high resolution, instead of just above the bottom horizontal line as I intend.
