Search results for query: *

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

Hi try using the format function in your coding; =[fldSymbol]& “ “ &format([fldTotal],"#,##0.00;-#,##0.00") Martin