• Julian to Gregorian Date Conv. in DB2 Web Query

    I have a julian dates stored in the format YYDDD numeric, 5 positions, zero decimal. How do I convert to a true Gregorian date in DB2 Web Query for iSeries?

    Screechtx0 pointsBadges:
  • Difference between QM Query and traditional query

    When both a QM Query and a traditional Query are run against a database file with IDENTICAL record selection, the traditional query returns more records. I can only guess that it has to do with a difference in the way each utility handles uncommitted data. It almost looks as if traditional Query...

    slateken230 pointsBadges:
  • DB Table/Query Layout for Ranking System

    Hello, I'm building a Membership DB where Members can achieve certain ranks (Rank1 - Rank14). I would like to present two things: - a list of all Members with their current rank and the Date the rank was achieved - for each Member a list of their ranks and the corresponding dates of achieving them....

    Artificial15 pointsBadges:
  • Changing query for report

    How can I cnage the query that I'm drawig data from so I don't have to re-build my report

    Starwars5 pointsBadges:
  • Search for Records Containing Word(s) in Textbox

    How can I bring up records from a table, by using a query, that contain words that are entered into a textbox on a form? I can only get it to work if I enter in the specific word(s) into the field criteria in design view, which is not what I want.

    Fechn5 pointsBadges:
  • SIL File, field ILQTY make it numeric

    How can I make the field ILQTY in the SIL file (for invoices) make numeric, so that I can make a count in summaries? Thank you!

    David4045 pointsBadges:
  • AS/400, BPCS, show only totallines (with all information), summirazid on ILQTY from the SIL-file

    Good afternoon, I made a query with some files like SIL, SSM and IIM. Now I want to summarize on quantities of sales (ILQTY, SIL-file) but other field (like 6 more or so) still need to be showed with only the totals per item (ILPROD). In my overview I get only Productitem and quantity summarized,...

    David4045 pointsBadges:
  • AS/400 BPCS difference between files with L01 and the files without (example ILI and ILIL01)

    In many queries after the filename L01 is used. Is this to get only the active records? Or can someone explain me what it means? Thank you! Rgds,        

    David4045 pointsBadges:
  • query, table relationships

    I forgot to make a relationship between tables causing all of my items to appear to have been made by every manufacturer. What is this type of error called?

    Zoellnerk5 pointsBadges:
  • AS400 Qry – Is there a way to trick qry into treating blanks as null?

    The data I need to sort on is in either field A or B depending on the transaction type. It could be accomplished by using the "value" expression if qry would consider a blank field as null. Any ideas?

    Sands5 pointsBadges:
  • MS Access query to show records that contain dates that differ by 1 year

    I have a table that is composed of 15 date fields. I want to make a query that will show the records where the there is a year difference between any of the 15 dates. I know that you can use the datediff function but that can only be used for 2 dates at a time. To create a datediff function for all...

    SerenityNow365 pointsBadges:
  • selecting a record from a table and printing ONE page report

    I have two tables that are joined in a query.  I have a form that points to one of the rows in the table.  I would like to print a single page report for the ONE row.  How do I do that from a multi-row form (with the appropriate row selected) into a MS Access Report?

    Michaeleemeyer15 pointsBadges:
  • iSeries Token Error

    Need help with this query - it will not run token error.  Here is the query: SELECT   SUM  ("T16.CTDT".TD_DETAIL_AMT_01 * .10) AS TOTAL, "T16.CPRP".CP_DISTRICT_CODE

    lorit365 pointsBadges:
  • as/400 query printing with DBCS data

    We are having some problems printing query reports since a software upgrade. The upgrade now has DBCS file data and print files. The strange thing is the reports will print on some select printers and not on others. It is very strange, some printers and set-up as *VRT Client Access and others are...

    ToddN200015,080 pointsBadges:
  • WRKQRY Security Flaw / Users can Alter/ Replace Data in Production Files

    Can a user change or replace data, members, or the file itself (a prodcution file in a production lib) using WRKQRY...??? I have an auditor who believes in the "Define the Query" display, 2nd to last option ("Select output type and output form") you can specify 3 in the output type (3 = datafile...

    Gambitt7150 pointsBadges:
  • Can a command button macro run a make-table query with an auto-inputted parameter value?

    I want to run a make-table query with a parameter, using a command button click event on a form showing a single record. The parameter value needs to be inputted automatically using the value of a control in the current record of the same form. Can this be done with a macro event? If so, what does...

    Shdrc5 pointsBadges:
  • Using the query to filter out the specifics

    Hello, i was just wondering if there is any way to use the query to filter out all the list with the word "mexT" in their lines/box. For example, in the column, there are bunch of lines with lines such as "cexT3df3#", aextT3rdfad" "mexT124ef3" "mexT235tgc#", etc.... but not exactly just mexT. How...

    Booya10 pointsBadges:
  • 0 Row affected

    Could you please assist with the following? UPDATE dbo.[Elution_Report_Template] SET [Elutriation_Set_SqM] = dbo.[Elution_Report].[Elutriation_Set_SqM], [Elutriation_Pump_SqM] = dbo.[Elution_Report].[Elutriation_Pump_SqM],

    GPNel200675 pointsBadges:
  • Running a lengthy query on SQL Server 2005

    We are running SQL Server 2005 and Windows 2003 Server. I ran a query in SQL on a PC with one dual code processor and 4GB and it took six hours. However, we ran the same query in SQL on a brand-new server that has 4 quad core processors and 32GB of RAM, and it took 12 hours. Why would this be?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Update field in table from a calculated query field

    I have a form attached to a query with calculations. How do I make the calculated values write back to the table?

    MahiraAgate15 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following