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”...
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...
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
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
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
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
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
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.