Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. rgreen511

    Put Access Report in the body of email

    Thanks for both of these posts. I tried some of the items in the second post's links, but I need to work out some of the bugs. I've tried to write code to export the query to RTF, then use this code to re-import it into an email, to no success, but I'm going to give it some more effort. I've...
  2. rgreen511

    Put Access Report in the body of email

    I'd like to put an access report, or alternatively an Access Query into the body of an email. The SendObject Macro option works very well for attaching the report or query to an email, but I'd very much like to have the contents in the body of the email. I can accomplish this by running the...
  3. rgreen511

    Link data to another Excel file excluding blanks

    Even more critical than the equations though is a graph that is showing the blanks as zeros.
  4. rgreen511

    Link data to another Excel file excluding blanks

    I have an Excel file that links to another file and grabs data using a simple link, no macros. The entries are of the format (ex): 11/27/07 12.3 Several of the entries are blank, and the blanks screw up my equations that are using the data (calculating moving ranges, etc.). I'm looking...
  5. rgreen511

    Eliminate blank entries in linked Excel file

    Thanks. I already did have the if statement to prevent that, but certain equations still treat blanks as zeros. And graphs treat blanks as zeros as well. I will try using MS Query. I'm fairly familiar with it, so I'll see what I can do.
  6. rgreen511

    Eliminate blank entries in linked Excel file

    I have an Excel file that links to another file and grabs data using a simple link, no macros. The entries are of the format (ex): 11/27/07 12.3 Several of the entries are blank, and the blanks screw up my equations that are using the data (calculating moving ranges, etc.). I'm looking...
  7. rgreen511

    scientific notation to specific power

    I got it to work, but kind of backwards. I was exporting the data from Access anyway, so I changed the Format property of the column to: 0.00"E-06" I think this worked in Excel too. I've never seen that documented anywhere, but it worked, so I'm happy. It's similar to concatenate, but much...
  8. rgreen511

    Scientific Notation Question

    Thanks. I was able to do it by entering this into the Format box in the column properties: 0.00"E-6" and using ([yourColumn] * 10^6)
  9. rgreen511

    limit decimal places when concatenating text and eqn.

    Thanks. I was able to do it by entering this into the Format box in the column properties: 0.00"E-6" and using only the lb/MMBtu: (([ppm]*(100-[% M])/100)/[BTU]*1000000)
  10. rgreen511

    scientific notation to specific power

    I want to format a column of numbers in scientific notation, but all to the same power of 10. Example, I want them all to be E-06: 1.20E-06 0.25E-06 2.57E-06 etc. Excel by default makes them all whatever power naturally fits. I'd also like to avoid a concatenate function since that gets...
  11. rgreen511

    limit decimal places when concatenating text and eqn.

    I'm using the following code, but I need to limit the first string to two fixed decimal places. How can I do that? lb/MMBtu: IIf(IsNull((([ppm]*(100-[% M])/100)/[BTU]*1000000)) , (([ppm]*(100-[% M])/100)/[BTU]*1000000) , (([ppm]*(100-[% M])/100)/[BTU]*1000000) & "E-06")
  12. rgreen511

    Scientific Notation Question

    PHV, I can't get that to return the result I want. The first term of the string I'm trying to concatenate is an equation that returns Null most of the time. When I use that equation, it puts the E-06 in all the cells, and in the ones that don't return Null, it doesn't do the math right and...
  13. rgreen511

    Scientific Notation Question

    Is there a way to have one column of my query display scientific notation to a specific power? Example, I want everything to be E-06. 1.26E-06 0.67E-06 etc. I couldn't find a way to specify it. Thanks.
  14. rgreen511

    extracting audio that is saved as sound OLE format

    I need to extract some audio from a powerpoint presentation. It is in the form of a click button that plays a sound. I tried exporting as html per this: http://www.rdpslides.com/pptfaq/FAQ00778.htm but that did not work. It had all the graphics files, but no audio files. Maybe the audio is...
  15. rgreen511

    block slide advancing in powerpoint

    I think that'll do it. Thanks.
  16. rgreen511

    block slide advancing in powerpoint

    Is there a way to prevent advancing slides in PowerPoint? I know you can turn off advancement with a mouse click, but using the arrow keys, or clicking the arrows that appear in the lower left also still work. I am developing training modules, and would like to create them so that they must be...
  17. rgreen511

    Excel query of Access query with varying date

    I have two question about new issues that just arose with this report. 1) Is there a function similar to DateAdd in MS Query, because several of the Access Queries use DateAdd in their criteria, and I can't find a simple way to implement that in the MS Query? 2) One of the Access queries I am...
  18. rgreen511

    Excel query of Access query with varying date

    OK, thanks. I think the key there is pointing the parameter to a cell, which I will try to do. When I have the query popping to get the dates, it would pop twice for each of those examples, but shouldn't if I reference it. Thanks again, this was so simple, I'm not sure why I never noticed MS...
  19. rgreen511

    Excel query of Access query with varying date

    I think this will do exactly what I want, thank you very much! One more question, I have it popping a prompt to ask me for the date. Is there a way to query using that date and the day before? I'm not sure what syntax to use. I tried subtracting 1, but I don't know how to indicate the date...
  20. rgreen511

    Excel query of Access query with varying date

    I am trying to modify a report that is built in Excel. Currently, an Access DB is opened, and data is exported using several queries and macros to 4 Excel workbooks, then the Excel report is opened, and it pulls the data from the 4 workbooks, very clunky. I'm trying to pull the data directly...

Part and Inventory Search

Back
Top