Search results for query: *

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

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

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

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

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.

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

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

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)

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)

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

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")

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

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.

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

I think that'll do it. Thanks.

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

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

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

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

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