Search results for query: *

SELECT Test.Strings, IsNumeric([Strings]) AS StringsNum FROM Test; Returns: Strings StringsNum 526897Bg-172866 0 2062150T 0 7070580757747V 0 706998 -1 1136473k 0 706995 -1 7072671209353X 0 706952 -1 573087 -1 1137338N 0 0629647n 0...

Glad I'm not the only one. It's very annoying. I've been using Access for years and have never had a problem with this. Hope Bill Gates can take care of this one soon.

I haven't run into your problem specifically, but I've also had some problems with the import wizard in A2K3. For whatever reason now, in the import wizard, when you click on subsequent columns to highlight them, any changes I type in (such as applying a field name) only overwrite column 1. I...

fkegley- I agree, I'm in the process of making macros to add and remove data elements from the details section. I plan to have a pushbutton interface for them. I don't know of any other way to make this happen. Thanks

Wicca I see what that does. It allows you to filter based on the values in each particular column. I'm looking for a drop down to select which column to show. Any other suggestions?

Wicca, What exactly do you mean? I'm open to suggestions, just need a little more explanation. Maybe it would help if I gave examples. Source Data Team ReportDate RepName Calls Hours Kept A 03/31/03 John Smith 150 100 25 A 02/29/03...

I agree, that step might work in a lot of applications, but in this case, there are too many variables to create individual sheets for each performance metric. My goal is to allow the user to select various ways to look at the data from one pivot chart.

Ok, I'm making a bunch of interactive charts for a department with my company. I have 15 data elements that I need to report performance on. These data elements lie across 8 different groups of people. The pivot table behind the chart is a simple one. Page headers include fields called...

Seriously, both of you guys rock! This works very nice. Thanks for your help!

Very cool. I haven't use the "Instr" function before. I couldn't find anything in help showing me an example of how to use it. One more question. Using the code above, I end up with "27!". How can I get rid of the "!" at the end. 90% of the records have this...

So is there any way to do it without using VB? I can do that, I just was hoping I could do it in the query. Also, I should mention that the "27" in that field, is variable length. Could be "8" in one and "300" in another.

I'm trying to figure out a way to parse a value out of a text string. The text strings are variable length, so the MID, Left, Right functions will not work. Is there a way to have it find a character in the string and take the numeric values to the right out and place them in a new field? For...

Or, if the field is a fixed length, you could use a simple Right command to eliminate them. If you're field with is 10 fixed and the first 6 are zeros, 0000007654 for example, You could do this NewField:Right([OldField],4) That would trim the field down to the 4 characters on the right...

You're right. I actually created this scenario and it didn't work as I had planned. Try adding a count criteria in there. Like this SELECT Musician.Musician_Name FROM Musician LEFT JOIN Instruments ON Musician.Musician_Name = Instruments.Musician_Name WHERE (((Instruments.Instrument) In...

I've had this happen to me before as well. I placed the input for the sort date (in your case) on the form itself. Then, in the query, I reference the input box on the form. In the criteria field for the date, for example, [Forms]![frm_FormName]![FormFieldName]. I don't know why, but this...

Assuming that Musicians table can be linked to Instruments table with Musician_Name Musicians Table: Joe Doug Instruments Table Joe Drums Joe Sax Joe Tenor Doug Drums Doug Sax SELECT Musician.Musician_Name FROM Musician LEFT JOIN Instruments ON Musician.Musician_Name =...