Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: nina200
  • Order by date
  1. nina200

    Queries that count duplicates

    Thanks Yall...I got it working by using the DCount() function... eg: DCount("[fieldname]", "TableName", "criteria") Thanks again. Nina ;)
  2. nina200

    Queries that count duplicates

    I have to find the number of items (exported and imported) and number of customers (imported and exported) then find the total of all these fields…. Here’s the details…when it comes to items there two types Warehoue and non-warehouse items…Warehouse items decs = “s”. Import/Export = either “E”...
  3. nina200

    Queries that count duplicates

    When/if I group this field it influences the values of the summary report... Nina
  4. nina200

    Queries that count duplicates

    hi, actually i'm trying not to use group-by there. Can't I get this done in the SELECT starement? like Select (iif(tablename.field = tablename.field, count(tablename.fieldname),0) From Tablename Where tablename.month = [enter month] AND tablename.year = [enter year]; I would like to have...
  5. nina200

    Queries that count duplicates

    Hi All I'm trying to write a query that count the individual values in a field e.g a field may have 2003 10 times and 3211 2 times...I would like count (without duplicates)...how do I do this? Thanks. I tried using COUNT() withing the IIF() statement to no avail. Nina
  6. nina200

    Function to display # of records needed

    Hi All, Can n e one assist me with a function to display a specific # of records? The user may input 200 and the query's supposed to print the first 200 records...of course I created the quwery to sort and everything but I haven't been able to locate a function to assist this need. Thanks Nina
  7. nina200

    Oracle Personal Edition and WinXP pro

    LKBrwnDBA, so can this be finally installed on an XP pro operating system? Cause I'm getting an error saying "there are no top level components for Windows NT available from this staging area". Thanks. Nina
  8. nina200

    Oracle Personal Edition and WinXP pro

    Hi, Is there any possibility of me getting Oracle8i personal edition to work on winxp pro? When I click install products it never bothers even to report "incompatable Operating System" or something. Nothing comes up. Nina
  9. nina200

    Oracle Enterprise Manager

    Hi, I tried all of the above ( and more) to no avail. I even tried installing the manager seperately ...but when I remove it I don't see an option to install it - while I can no longer see it under the Installed components. N e help will be appreciated. Thanks. Nina
  10. nina200

    Drivers for Dell 2400

    No, it's a Dell Dimension 2400 and Xp drivers wont work - I tried it all. I even went as far as the flash the BIOS and then dell usb I/O devices. Nina
  11. nina200

    Drivers for Dell 2400

    Hi all, I have installed windows2003 on my dell 2400 and noticed: 1. There's a need for updated drivers for sound, usb i/o devices and network adapter (when the network adapter shouldn't post a problem since it's onboard and win2003 should cater for this). I even visited the dell website for...
  12. nina200

    Oracle Enterprise Manager

    Hi, I'm completly new to Oracle(8i) and just installed Oracle Enterprise Edition on my Win2003 server system. The problem is after installing this I know the Enterprise Manager has been installed but it's like I cannot find it on my system. Is there under someother name - I've checked all the...

Part and Inventory Search

Back
Top