Search results for query: *

I am trying to pull certain cases from a table, and am not sure how to do this. Here is my query that I am running: SELECT TOP (100) PERCENT dbo.VW_Triage.CaseID, dbo.OrganTissueGroup.Category, dbo.OrganTissueGroup.OrganTissue AS Expr1 FROM Tissue.RecoveryTissue AS TISSUE INNER...

Hello, I need help in grouping together values in a field. Here is my query: SELECT Admin.OrganizationToType.OrganizationId, List.OrganizationType.FieldValue FROM Admin.OrganizationToType INNER JOIN List.OrganizationType ON...

Sample of Table data: Name of Table: LG_LAB_RESULTS SAMPLEDATETIME CREATINE ID# 2011-10-02 06:43:00.000 2.5 191613 2011-10-02 16:27:00.000 2.6 191613 2011-10-01 04:15:00.000 1.6 191613 2011-09-30 03:20:00.000 1.8 191613 2011-10-01 19:44:00.000 1.8 191613 2011-10-02 02:41:00.000 2.3...

I have a column of percentages that I want to use as data labels in a graph. The labels, however, need to display as whole numbers/ Anyone know a special format formula to accomplish this? Thanks

I am working in Microsoft AccessI have a table call Lab_results. I need to pull the value from the field "Creatine" based on the the last date in the field "Sampledatetime". Is there an expression I can use to acheive this? Thanks

I have a general question. Is it possible to create a table in Excel with column headers that, when clicked, will allow allow data entry to specific assigned cells? For example, say that every time I clicked the Name in column B Row 1, that Cells B4 through B8 would open for data entry. Is...

I have a general question. Is it possible to create a table in Excel with column headers that, when clicked, will allow allow data entry to specific assigned cells? For example, say that every time I clicked the Name in column B Row 1, that Cells B4 through B8 would open for data entry. Is...

I know this may sound like a dumb question, but is there a way to export an a single Access report into distinct seperate reports by page break? Just curious.

Having problem with an Excel formula. I have a worksheet I have named 12-25. There are two columns that I need to compare from, which are b2:b54, wich is a date column, and d2:d54, which is a text column. On a seperate worksheet, I am trying to count how many times a given value in d2:d54...

I am trying to create a table from a stored procedure, and am getting the following error code: "Server: Msg 156, Level 15, State 1, Line 2 Incorrect syntax near the keyword 'AS'." Here is the code I am trying to run: CREATE table donors AS SELECT dbo.VW_Case.ReferralDate...

I need help in writing an expression in an Acess query. I need to look for the minimum date foe a particular set of records, and then return the coresponding value for that minimum date. The table I am working with is: VW_SODIUM SURVEY LAB I need the minimum date from field: Sampledatetime...

I am having trouble getting my view to just display the maximum date from a set of records. The SQL for the view is as follows: SELECT DISTINCT dbo.LabProfile.SampleDateTime AS SamplDateTime, dbo.LabProfile.CaseID AS Expr1, dbo.LabItem.[Value] AS Expr2...

I need help. I have 2 columns on worksheet entitled 10-07, and I need to have a function that looks for specific values in each column, and return the result to a seperate worksheet. Here is what the columns look like: Region Code Sum North 502...

I am new to SQL, so please bear with me. I am trying to copy a table from one database to another within enterprise manager. Would I use a custom view to copy the table of should I use a User Defined Function? The database names at "DT" and "QA Reporting database". The name of the table I am...

I have two tables linked by ID number in a query. I am grouping by the tissue specific deviation field, but am getting repetative returns like the one below. Region Tissue Compare Category TissueOverallDispositionText DonorTracCaseID StatTracId TissueSpecificDeviationValue Southeast Bone...

I have a count field which supplies a value of 1 for each record in my query. I also have a region field which identifies the record by their geographical location. I have grouped together all the records, and and am trying to perform the following: 1. Total sum of the count field. 2. Sum of...

I am trying to duplicate an extremly complex report from an older db in a new acess db. Here is my problem: The query fields I am using are entitled "Region", "Heart UNOS Code" and "Heart Recovery". I am trying to retrieve sums of the "Heart Recovery" field based on distinct values in the...

i am trying to populate a column based on certain criteria using a CASE command, and I am getting "ADO error: Invalid syntax near the keyword 'AS'. Here is the code: CASE WHEN DBO.VW_RPTELIGIBLEORGANDONOR.REFERRALTYPE = 'REGULARREFERRAL' AND...

Please forgive my ignorance, but my knowledge of SQL and VBA is very limited. I have a table with a field entitled LAST MODIFIED. The table is comprised of both a date and a time value. I frequently import new data into this table, with changes to the individual records, which is reflected in...