Search results for query: *

kjv1611: Thanks for reminding me. I did vote for you and other members who posted. In my opinion, everyone who posts (even if their input is not helpful) should be thanked either by 'generally accepted medium of a click' as you put it or a thank you note via posts. I have always thanked people...

Thanks all. I forgot that 'Find' has option to select from current sheet or workbook. It's lot easier. Once again, thanks all for sharing.

We use MS Access 2007. When I run any report, it shows report but does not give me option to export to Excel. I can export to other formats (pdf, xps, etc.) but not to Excel. Excel option is grayed out (disabled perhaps?). Where can I find setting that will allow me to export reports to Excel?

Thanks for sharing your macro. That's a very neat macro if you know names of all your tabs. I am sure someone knows how to get names of all tabs so (a) you don't have to hard code it and (b) if you add/delete shheets, you don't have to update the macro.

I would like to do find on whole spreadsheet; is there a way I can select all tabs (sheets) and issue a find command?

I found the settings and ours is set to 5000 and it seems that there is just one setting for the whole server and not individual settings for each job but I can't figure out why some jobs' history is there for months and others is there for only days?

Thanks both of you. I will check it out.

We are using SQL 2000. Where can I find (or set) how long job information is kept on jobhistory/sysjob tables? It seems information about some jobs is kept for months while others is only few days. I want to look at old abends for few jobs.

Thanks both.

How can I get column names from a table that doesn't have any data or has data (just like DESC command in Oravcle)?

I tried but here is dilemma. Let's say I want to delete dup acct numbres. If my table looks like ID Acct OtherFields 1 11 2 11 3 12 4 13 5 13 I want delete two dup (one 11 and one 13). The Wizard gives four records, 1, 2, 4 & 5. 1 11 2 11 4 13 5 13 Is there a...

Thanks Randy! I haven't used that perticular query wizard but makes sense to use that. I appreciate your response.

How to delete duplicate records from table/query? Let's say, in a table there are 9 fields fld1 through fld9 and organized/grouped by least occuring to frequent occuring from fld1 - fld9. If I want to delete all duplicate records that match on fld1, fld2, and fld3. How would I do this?

Thanks! Forgot all about UNION. I tried and it and it works like a charm. Once again, thanks to all for responding. This is a great site; I learn a lot from this site through everyone's participation.

Thanks! One question--since we are joining (union) left outer join and right outer join, wouldn't this double records that are in both tables? Bother outer quesries would include records in both tables.

Does anyone know how to do outer left and our right joins in a same query? If there are two tables, I want to get records from both table whether there is a match or not. For example, we would join on A-ID and B-ID TableA Table B A-ID A-Name B-ID B-Name 1 AA...

OK. Thanks! My apologies; didn't read first line. This solves my problem. Once again, thanks to all who responded.

Thanks! It worked for blanks. Now I need to work on combining both in one select statement. If fld2 is blank or NULL, DoThis Else DoThat.

Thanks! That worked like a charm for NULL. I checked web but can't see anything similar for blanks. Would Nz catch NULLs and blanks?

Can I use two conditions in one IIF statement, for example, If DEPT_NUM is blank or NULL, make DEPT_NUM = '9999'. I am having trouble with even just 1 statement, as following select fld1, IIF(DEPT_NUM = NULL, "9999", DEPT_NUM), fld3 from Tbl_A