Search results for query: *

using visual studio 2008 V3.5 sp1 i HAVE A TARGET FLD DEFINED: xfld (DT_STR,30,1252) I HAVE A FORMULA HERE for xfld: Im comparing 2 year fields IE: 2008 = 2008 (CAST([YEAR] AS VARCHAR(4)) == CAST([CUR_YR] AS VARCHAR(4)) ? [STATUS] : "CLOSED" if they are = then xfld = STATUS if <> then...

thanks... Dagon for the post Ill look it over later today and let you know jim

select column_name from user_tab_columns where Upper(table_name) = 'AFACT' MINUS select column_name from user_tab_columns where Upper(table_name) = 'VW_AFACT' / THIS DID find the 3 fields missing in the view. this is great. But this leads to another question. For every table and view I...

thread1177-795377 http://dev.fyicenter.com/faq/oracle/oracle_managing_user.php jim

select column_name from user_tab_columns where table_name = 'afact' minus select column_name from user_tab_columns where table_name = 'vw_afact' THERE ARE 3 FIELDS IN THE TABLE THAT ARE NOT IN THE VIEW CREATE or replace view vw_afact ( nsc_ps_enr_fact_key ...

Hello I did try the minus from user_tab_columns as suggested. The sql pulled all of the fields from the table. Not just the 3 missing in the view. I then added all the fields from the table to the view The results from the sql were the same as before. All fields selected from the table jim

yes this is the approach we have here... Create or Replace view test_view as select field1,field2 from my_table) Im not sure how your solution here works( but thanks for the response by the way) Lets say I have only one table in the view and the view is missing added fields in the table. How...

oracle 10g I have views on tables in oracle that I need to check to see if the views are current. Sometimes we add a new field to a table and recompile the view. But, the view wasnt changed to reflect the added field in the table. this is on our dev DB... We have many contractors thru here and...

got it! thanks john for the code Dim Criteria As String Criteria = "([OffTypeDesc] = '" & Forms!fCBox.Form!cboOffType & "') AND " Criteria = Criteria & "([FileTypeDesc] = '" & Forms!fCBox.Form!cboFileType & "')" DoCmd.OpenReport "rptqCBoxes_w_Years_exp2", acViewPreview, ...

yes it does show the correct records

neither have a quote in the field but thanks Ill keep this for future reference Seems using 2 feilds is a no no in Access based on this board and ITtoolbox as well. Access is a funny beast -- I have problems using the wizards to open a form ( single record) based on a subform. I was...

good suggestion There are now 3 records on the form( filtered) I have copied your code in - fired off the report - but only 2 of the 3 records show. Same results as the code I was trying before I have heard of others having issues w/ a 2 parm docmd. thanks for your effort. jwa

I noticed that as well its something w/ this editor that put those in but thanks for noticing jim

this is pretty straight forward. I want to open a report based on the same qry as the form. I am using the form filter values ( which work) to open a report / the same record set - which isnt working. this is the command. DoCmd.OpenReport "rptqCBoxes_w_Years_exp2", acViewPreview, ""...

You could create the county totals all in one query with a subquery. I'm not sure a report would allow you to use this result from the subquery as the control source for sorting and grouping. Ill try and let you know thanks for the list of books -- and I appreciate it jim

I think that is what I was leaning toward. -- a trail of querys. I assumed that Access had more features than it does. In Oracle ( which I usually work in) I could write an in line view and then select off the county and add the detail records all in one sql. Nothing under the hood and fast...

yes I have thought of a totals q by it self. Then build a detail q off of that one hooking up on county. Can you have 2 querys as the recors source to a report>? And, thanks for your reply dhookom. jim

hi all I have a rpt based on a qry fields are county exp type cost period - there are 3 periods I am dealing with that means 3 cost amounts per grouping ( county) this is the sum at each group level ( county) =Sum([Cost]) I need to order by highest to lowest group sum amount.=Sum([Cost])...

Im am pondering this. I have a chance to move to a new employer. The $ is about the same. They are going to EPIC ( health care) and the demand for reports writing is dire it seems. I have some CR experience. I have done alot of pl\sql as well. I love writing sql( weird I know) -- its the...

Then BO must have decided not to faze out native sql. When seagate went to CR10 they cut out the sql designer and gave us a black box for 8.5v to 10v migration. Im glad they went back....Sql is too damed flexible to throw out jim