Search results for query: *

Thank you all for the help. I took your suggestions a tweeted tham a bit, but it is working. As you can probably guess, I am not very proficient at SQl. Thank you all again for your help. I really appreciate it.

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...

Ok, let me try to explain again. Forgive me in advance, as I am not very proficient with Programming. Here is the query I am running right now: SELECT OrganizationId, FieldValue FROM dbo.ORGANIZATIONTYPES ORDER BY OrganizationId The results are as follows: OrganizationID...

Thank you for your assistance, but this does not produce the results I am looking for. Thank you anyway.

Here is sample data. Organizationid Fieldvalue f15e61d8-10d8-49a2-a56f-005697d5cd4f Hospital f15e61d8-10d8-49a2-a56f-005697d5cd4f Southeast f15e61d8-10d8-49a2-a56f-005697d5cd4f Transplant Center I would like to get group the organizationid column into single rows for...

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...

Well, what I did was to run to seperate querys to pull the creatinine value for the maximum sampledatetime. Using the queires, I created a table to then use with another table.

Thank you guys. I got it worked out. I appreciate the help.

Does not work. I just need to pull the value of the creatinine field based on the max sampledate. I don't need to include the id. Thank for your help.

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

Thanks for the response. Is there a way to do this in Access Jet SQL? In other words, is there a way to input this into the criteria field in design view of the Access query? 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

Let me try this another way. Let's say I have 3 columns, and there are 10 rows. Now when I click the header column A, then calls A1, A2 and A3 are each available for dataentry. Now, when I click the header for column B, cells B4, B5 and B6 are available for data entry, but not B1, B2 or B3...

Sorry if I am not being clear. I just want to enable data entery to specific cells a given column when the header for that column is clicked. Does that make sense?

No. What I mean is when you click on cell B1, that it would activate cells B4 through B8 for data entry. If B1 is not clicked, then the cells are closed.

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...

Thank you very much. I will post this question there.

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.