Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. gjmac2

    Need Help

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

    Need Help

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

    CONCAT

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

    CONCAT

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

    CONCAT

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

    CONCAT

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

    Help Pulling Max Date

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

    Help Pulling Max Date

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

    Help Pulling Max Date

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

    Help Pulling Max Date

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

    Display Percentage as whole number - Excel

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

    Max Date Problem

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

    Max Date Problem

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

    Excel Cell opens Specfic Cells

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

    Excel Cell opens Specfic Cells

    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?
  16. gjmac2

    Excel Cell opens Specfic Cells

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

    Excel Cell opens Specfic Cells

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

    Open select Cells by clicking a particular cell

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

    Open select Cells by clicking a particular cell

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

    Export Access Report by Page Break

    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.

Part and Inventory Search

Back
Top