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!

  • Congratulations Chriss Miller 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: LostCait
  • Content: Threads
  • Order by date
  1. LostCait

    Converting Text to Date

    I am sure this is an easy one for some of you, but not being an expert in SQL or in Access2000 so I am stuck! I have a linked SQL table in Access that has a field containing dates formatted as text. The dates are text in the form 20050817. In my query I need to change this column of data...
  2. LostCait

    How can I get this underlay to work?

    Hi! I have a subreport in a Detail B section. That subreport has no report header or footer. It has has a GH1 and GF1, and a suppressed Details section. I am only printing out the GH1 and GF1 to show earliest and latest values for the groups. I want the value in GH1 to print next to the...
  3. LostCait

    Triggers & Index Question

    I am using DTS with Enterprise Manager to copy a table that exists on our server. I only want to copy certain rows of the table into the new table, and I have a query that does that. I want the new table to have the same triggers, indexes, etc. attached to it that the original table has. When...
  4. LostCait

    Strange Character on eWay for HL7

    Has anyone used eGate as an engine with Meditech? I have created the inbound ADT eway from Meditech to eGate which is HL7v2.2, but there is this strange character appearing in when I test the file on the eway. It almost looks like a Japanese yen symbol before each message segment. Has anyone...
  5. LostCait

    I need to purposely Skip a page

    I hope you can help me. I have a report, with three different groups. On the header for the first group - by name -I have new page before, reset page # checked, and on it's footer it have new page after, reset page# checked. On the second group - by category, there are no conditions on the...
  6. LostCait

    How do I skip a page when Duplex Printing??

    HELP PLEASE!! I have a report which prints out member records. I have the report working great now for one-sided printing - having the member name footer have a "New Page After" when that patient is finished printing. I also reset the page number several times in printing that...
  7. LostCait

    Can't read first record Data?

    I created a report for a SQL2000 application I have running on-site. The application runs a SQL statement that creates the records, the report does the formatting. However, it looks like that for the first record of each grouping I have, the report cannot read one of the data fields - it is...

Part and Inventory Search

Back
Top