Search results for query: *

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

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

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

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

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

I inherited an Access97 datatbase, where the primary transaction table has large records. its ID# is a Long-Integer AUTONUM. It is NOT a key or an index. Occasionally, a record gets created where it has a dupliate ID#, somewhere in the middle, not the last-number. Almost always, the rest of...

I need to simultaneously preview the same report several times, each with a different filter. Then the user shall close or print the open report(s) they desire. I created a button that does the series of &quot;DoCmd.OpenReport&quot; commands, each with a different filter. The code compiles...