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...
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...
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...
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...
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.