for tables:
SELECT TABLE_NAME,COLUMN_NAME
FROM FND_TABLES, FND_COLUMNS
WHERE FND_TABLES.TABLE_ID=FND_COLUMNS.TABLE_ID
AND FND_COLUMNS.COLUMN_NAME LIKE'%SSN%'
ORDER BY table_name ASC
For Views:
SELECT view_NAME,COLUMN_NAME
FROM FND_views, FND_view_COLUMNS
WHERE...
Right hand click any where on the top tool bar( you have to right hand click a blank bit i.e beside the help button) and tick the 'Window Bar' box that should bring back the bottom bar.
On your query view right hand click where you see the fields you mention - on the Customer ID field select group by , then the year field select count , then the amount field sum - or the SQL view would be :
SELECT [TBL-Customers].[Customer ID], Count([TBL-Customers].Year) AS CountOfYear...
What is the ActiveX control?
If you are using the Date and time picker control you will need to have a look at the time properties(It will always defualt in the time you created the control). Is the data you are trying to qry have a time stamp?
Hi
Hope it is of use coding to do both zip and unzip
Function ZIP()
'TO ZIP A FILE
Dim FileToSave As String, ZipFileName As String
FileToSave = "C:\YOUR_FILE_TO_ZIP.TXT"
ZipFileName = "C:\YOUR_ZIP_FILE"
Call Shell("c:\Program Files\winzip\Winzip32.exe...
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.