Recent content by cp950

I know SQL_Server does it. Is there an MS_Access option that'll show NULL fields as something other than blank? Zero-Length would look like " " Space would look like " " NULL would look something like "<<null>>". I have a DB with poor NULL handling and it would be a huge...

You could do it in the SQL source... SELECT * FROM [Comments] CCC WHERE [Date] = (SELECT Max([Date] FROM [Comments] AAA WHERE AAA.Date = CCC.Date

I am using SSRS and Visual Studio 2012. I had to completely rebuild a subreport (major changes in data content, etc.) but it still uses the same parameters (from/to dates). I created it, verified it, exported it to EXCEL -- it was 100%. I added it as a subreport to my main report. When I...

SUCCESS!!! I had been getting a row of ######## as wide as the cell (in some rows, not all!), had it set for autofit and text-wrap, but kept getting only that one row of #########. Some of my comments are a dozen lines long and some change daily, so manually inserting alt-enters just cannot...

Never mind -- moron (me) left a comma of line #06

I am writing a DTS package that'll acquire data from an Oracle database to make SQL updates. The first step is a data-transformation into an existing SQL table. I used a SQL statement as the source (one source table with 8 left joins). My problem: no matter how I write it, I get an error...

I did not even know how to search for this, though I did try... I am using Access_2000 to collect user data. When done, I insert it into a SQL_2000 table. Access PRICE field is Currency, and the SQL field PRICE is Float. I am moving the data with a simple append query. The kicker...

Found it on the 10th search of Seagate's support system! 1) Delete the group 2) Re-Insert the group It now sorts correctly. I don't get the logic of it, but it DID work...

Turk: No, its a SQL datetime. I figured if it was a text I'd see the date in month and date order, but nope!. I can determine NO form of order -- not even DAY (Fri, Mon, SAt, Sun...)

Ms. Vampire : (like the ID! [wink] ) I checked, and they are set that way. I also checked keep-together and repeat-on-new-page. No difference. Spooky, no?

I created a new report (CRW version 7.1) that takes in a single record-set (MS SQL view, unsorted) and prints a summary (summarising transactions by COUNTRY within DATE). I set the details up for the records and suppressed it. The Date and the Country fields ARE in the suppressed detail. I...

OK, thank you VERY much! And if I needed to use this data in subsequent queries, I could make this query a Make-Table type, and off I go. Right?

I need to pull the &quot;TOP n&quot; of a table, based on simple criteria (like Top 3 Salarys of employees, where Department = X). I know I can set &quot;n&quot; easily in design-mode, but this I need to run by form by a user who won't know Access. The &quot;n&quot; will always change (Top 5...

OK, I am back. I made a number of tests, and did a bit of research. I have ruled out the import, as the days this last one appeared the imports-preson was in Omaha. But the fact still sticks in my craw that the last chinese-character record I got had a whacked Autonum. ((to clarify, the...

JIM: Thanks for helping! Yes, the &quot;invoice number&quot; is used throughout the company's processes. Trying to change it to something else would be unacceptable to them, and I fear quite foolhardy. I fully plan on checking for unacceptable values (nulls, dups, etc.) and making the thing...