Search results for query: *

Thank you for your response to my issue. As a novice to all this I will try to do my best in explaining the steps . . ok.. so data on sheet1 columns a-g= a: Name b: email address c: phone d: address e: state f: # of claims g: claim so when pivot data is grouped on "state", it will show all...

is it possible at all to have an active hyperlink in excel 2003??? i can not find anything anywhere.. completely frustrated.. my purpose is to open a word document from the excel pivot table.. the document associated with whatever corresponding cell... i know there is a miracle worker out here...

This is Excel Question Pivot Report Question

I reposted... i didn't clarify.. EXCEL 2003 pivot table.. Does anyone know if there is a way.. or code or something that exists.. that if my report has 2 page fields.. and one of the page fields is selected, it will prompt... or update / refresh the corresponding page field on the same...

Does anyone know if there is a way.. or code or something that exists.. that if my report has 2 page fields.. and one of the page fields is selected, it will prompt... or update / refresh the corresponding page field on the same report???? for instance.. 2 page items are STATE, CARS, row field...

i'm not sure how to define it.. what is the correct way? I'm new to this. Thanks for your help

ok.. sorry.. sent the wrong one.. strSQL = "SELECT top 25 tbltemp.lso_id, tbltemp.lso, tbltemp.am, tbltemp.borrid, lastcalcs.lastcalcdate, lastcalcs.calctype, tbltemp.borrowername " & _ "INTO " & strTableName & " " & _ "FROM tblTemp " & _ "Where...

Thanks, for that.. the where clause.. ok.. here's the whole code.. i'm trying get a total of 25 random records and of those 25 random records have 5 records for each lso-ID.. here's the code.. any idease? Sub PickRandomR() Dim db As Database Dim tdf As TableDef Dim fld As Field...

anyone see what's wrong with this? 4: Sort the data by the random number and move the top 25 into a new table strTableName = "tblRandom_" & Format(Date, "ddmmmyyyy") strSQL = "SELECT tbltemp.LSO_ID, tbltemp.LSO, tbltemp.AM, tbltemp.BorrowerName, tbltemp.LastCalcDate, tbltemp.CalcType "...

Need help the module below works great for producing random records, however I have 7 users that I will need to match for, meaning.. i need top 3 random records for 5 different groups-i saw group because i read somewhere that i need to use a group statement.. so maybe group isn't a good term...

No i'm sorry.. maybe I can paint a better one though.. lets say.. query name is customercalculations Customer redcalcdate bluecalcdate lastcalc type john doe 4/12/2007 4/25/2007 4/25/2007 bluecalc jane doe 4/7/2007 4/1/2007 4/7/2007 redcalc joe shmoe 4/5/2007 4/5/2007 4/5/2007 both

I'm doing something wrong here.. looking at 3 date/time fields: 1)RedCalcDate 2)BlueCalcDate I'm querying for the [lastcalc] or the most recent date out of the calc datefields for that record...and all records last calc date in the current month.. which I got that fine, but not I'm looking to...

ok, got the input box to work, however when prompted, and user inputs number, it limits the results to that figure. I need it to limit the results to each individual. example- Joey has 20 records Tom has 10 records Lisa has 5 records when user inputs number, lets say... 3 then I want to see 3...

Love the quote by the way!! Silly question maybe.. but where do i put this? in the same module? or... other option?

I've created a query, and in a module formed a code to randomly select records for an audit sample from a query. I'm stumped on the next part... I'm trying to accomplish the following: The results contain various fields of data for 6 different individuals. Criteria for the query is if the parts...

OK, I just realized that the table field that has the string data in it, is a memo type field. Does that have anything to do with how i'm going to parse the data? I'm frustrated with this because i know that it is possilbe to do what i'm trying to accomplish. I know there is a way. the field...

I was so excited to get your response! Thank you! This is WONDERFUL!!!! I inserted your code into a new module is there a secret to making this work? Again, I'm a novice when it comes this stuff! I guess my question is, how do I "call" this code to my query? I guess that is the correct term.

What I need to tell is the difference between the Required and actual value.

if blank then there isn't one present. the info you have above is correct. sign off note is null.

This is awesome! How do I got about doing this?