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: *

  • Users: gjmac2
  • Content: Threads
  • Order by date
  1. 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...
  2. 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...
  3. 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...
  4. 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
  5. 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
  6. 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...
  7. 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...
  8. 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.
  9. gjmac2

    Excel Formula Problem?

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

    Help Creating a Table

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

    Help with Access Expression DLOOKUP

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

    Selecting the max date

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

    Help with Excel

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

    Help with UDF

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

    Multiple Rows in Query

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

    Problems with IIF in Access Report

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

    Need Help with IIF and Report

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

    Having trouble with CASE command

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

    Need help Comparing Dates

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

Part and Inventory Search

Back
Top