Search results for query: *

Sorry for the long delay - got sidetracked with another fire. We all know how that goes! The Access table is a linked ODBC table on our SQL server. The query is a pass-through to that table. If I try to import the table to Access, the date field shows as a memo format. However, I do not...

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

As we all know, priorities change quickly and being the only programmer onsite means mine change hourly! I thank you both for your suggestions - I incorporated the second GH1 and put in the mod formula. It worked to a point - it didn't like the header being suppressed, so I made the smallest...

Thanks for your help! I had a version of the remainder formula, it was the GH1a I am missing. I will try the easier formaula and the header and see how it goes. I'll let you know. Yes, complication is my forte!

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

I created a formula to keep count of the pages being printed regardless of grouping, because I too was resetting after each grouping. Here's what I used in the page footer although you might find something more efficient: Formula: @PageCounter global numbervar PageCount; PageCount :=...

Thank you for the response! If I have declared a variable used in a formula in the page footer as Global, will I still be able to access it in the second group footer? Here is the simplistic formula I am using for my cumulative page count in the page footer (I display it to a suppressed...

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

Has anyone had the problem that when a user uses the scroll wheel records are added to the database? On one DB, if a user uses the wheel, nearly 5000 blank records get added to the table. Since it is a DB in limited use (only 9 people have to remember not to use scroll), it's not too big a...