Search results for query: *

Hi - I'm trying to use the upsizing wizard. I've upsized a copy of this database before and did not have a problem. I think I"m doing it the exact same way... Anyhow, when I enter the SQL Server to use (local) and check add trusted connection, set a database name, and hit "Next", I get the...

Hmm, what is this DAO help file and how do I access it? (sorry, can you dumb that down a little?)

Anyone know a quick way to copy or export a list of fields in an Access table to Excel? I'm trying to generate a list of tables/fields in a database, but the table design view doesn't allow copy/paste. Thanks! Liz

Hi - I'm trying to export a table to a csv file (via exporting to Excel and then saving as csv), and am finding that numbers are being truncated from 15 to 9 decimal places. Any tips on preserving the decimal places? thanks, Liz PS - sorry if this one's already been covered; I searched, but...

Thanks, Skip. So I have three columns, A , B, and C. For my lookup, if there's a match in column A, I want to start the lookup in column B in the row right below that match. Does that make sense? I put an example of it below, but I'm not sure the formatting will work. Depth to water table...

Hi there, I'd like to know if it's possible to adjust my range for a vlookup using the MATCH and ADDRESS functions. Basically, I'm using MATCH to find the row where I want to start my lookup, and using ADDRESS to convert the MATCH result to a cell reference. Looks something like this...

Yeah, I think the only way to do it is to create a macro to run the function. Actually, it was "naughty by nature", but dynamic by nature could be their cover band.... Thanks, John.

Hi, I'm using the random number generator in excel and want it to calculate only once. The goal is to generate a list of 8 numbers one time using 8 instances of that function, and then to disable the function from re-calculating. I want to be able to preserve both the function in the cell and...

Ah...it never occurred to me that it could be a typo. Thanks again everyone. These tips were *exactly* what I was looking for.

Thanks! So why on the msdn site does it list the range for "y" as 1-355? What is it I'm missing?

Sorry, where do I try that - in the query somewhere? I *did* try just Format(#2004-12-31#, "y") and it works! But I'm hung up on the MsgBox part... Thanks for bearing wtih me!

hey - you're right! sometimes I need it spelled out : ) So my next question is why is the range for the "y" format 1-355 instead of 1-365 or 366 as per: (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbenlr98/html/vafctformat.asp)

Actually, I'm looking for Day of Year (1-365), not Julian Date. I think Jeff's suggestion will help me though. Thanks everyone! Liz

Does anyone know if there is a canned function anywhere to convert a date (or month/day) to a number from 1-365? I know it would be pretty easy to create something to do this, but I don't want to re-invent the wheel if this already exists. Thanks! Liz

Hi, I have some relatively simple data entry forms set up to update a table. While entering data on one of the forms, I suddenly got an error saying "Invalid Argument" and much of the text in the form was converted to Chinese characters! When I clicked "help", I was given the following...

Hi, I have some relatively simple data entry forms set up to update a table. While entering data on one of the forms, I suddenly got an error saying "Invalid Argument" and much of the text in the form was converted to Chinese characters (!). When I clicked "help", I was given the following...

Never mind - I got it - Woo-Hoo! I needed to do this: SELECT CopperQuery.location, CopperQuery.result, CopperQuery.units, CopperQuery.depthfrom, CopperQuery.depthto, CopperQuery.date_sampled, CopperQuery.time_sampled FROM CopperQuery INNER JOIN (SELECT CopperQuery.location...

This is helpful - I'm almost there. I have the following typed in: SELECT CopperTable.location, CopperTable.result, CopperTable.units, CopperTable.depthfrom, CopperTable.depthto, CopperTable.date_sampled, CopperTable.time_sampled FROM CopperTable INNER JOIN (SELECT CopperTable.location...

Yes, I realize that, but how do I select other fields associated with the max value *without* grouping by those fields? For example, if samples were taken from Point A at 3,5, and 7 feet. and the maximum is 100 ppm at 7 feet. I want the query to select: Point A - 100 ppm - 7 ft

Hi, I know this is a really basic question... I have a table of results for locations. Each record is assoc. with a date, time, and depth. Some locations have multiple results. How do I select the record (including relevant depth, date, time, etc.) for each location at which the result is the...