Recent content by crisenr

  1. C

    Display a record once if data in two fields have matching record

    Hello eveyone . . . i am attempting to create a VERY complicated query . . . it's sort of confusing: I recieve data from an outside source and it is up to us to format it for our own analysis . . . i have fields: MethodCode..... AccNo .....PatientName.....MR..... TestCode ..... etc, etc The...
  2. C

    Attach multiple reports in an email?

    how do you attach multiple reports in an email through code to put behind a button?
  3. C

    Using charts in reports . .

    what is the best way to use a chart in a report?
  4. C

    Filter a report so it doesn't display certain records

    hey everyone . . i've got a report which pulls its data from a query. it pulls these fields:TestCode...Price...HID...Month...etc . . . There are names of "TestCode" that we don't want to display, is there a way to filter certain "TestCodes" out? if so, how? Here's my current SQL Code: I have...
  5. C

    Filter a report so it doesn't display certain records

    hey everyone . . i've got a report which pulls its data from a query. it pulls these fields:TestCode...Price...HID...Month...etc . . . There are names of "TestCode" that we don't want to display, is there a way to filter certain "TestCodes" out? if so, how? Here's my current SQL Code: I have...
  6. C

    How do i format this syntax . . .

    This is my current SQL Statement: SELECT [qryGroupByAMCount].[TestCode], [qryGroupByAMCount].[Price], [qryGroupByAMCount].[HID], [qryGroupByAMCount].[Month], [qryGroupByAMCount].[CountOfAutoNumber]...
  7. C

    Query to Calculate field depending on Value of another field?

    hey guys . . I have 3 fields: TEST, NETQTY, EXTENDED NETQTY usually = EXTENDED depending on the TEST BUT the Test PTCGCD has a EXTENDED value that is TWICE the value of NETQTY How do i create a query which will update the EXTENDED field depending on the TEST value>? For Example: The...
  8. C

    Query to filter out "duplicate" data

    Ok i've got a table with about 105,000 records. It has fields: AccNo, PatientName, MRNO, TestCode, OrderLoc, DOS, TOS, etc, etc. The table does have records that WE consider as a "duplicate". If two records both have the same "AccNo" & "TestCode", it is CONSIDERED a "duplicate". I need a...
See more
Back
Top Bottom