Recent content by pwoodj

Ok, I have a query that has a range of number for 1 - 126, I need and an expression that will flag sub-ranges in the list of numbers. Example I want to group or flag results 0-25 as one group, 26-50 as another, 50 - 75 and 76 -100. Any ideas? I statred with an IF than expression, but I can't...

I figured is out... I started to remove the expressions from the end of the query, and I was able to run the query. Adjusted the expression, runs fine now..

Ok I've looked but can't find anything about this on the forum. I have a query thats getting a Data Mismatch in an Expression error. Is their a way to locate or identify this error, I have about 40-50 expression in the query. I've eye balled all of them and nothing is jumping out.. any...

This might be an easy one, but I'm not getting it to run. I have a table with school years and enrollment grades stored, I need an expression to find out what a student's enrolled grade was in 2004 (last year). Any Ideas? as always thanks..

Got on more question (I hope) about functions. I have a table that contains a year (school year) and an End Status Code, I need to flag students that have the end status code of 45 in school year 2005. When I use the below code the column popluates with "#ERROR". IIf([ST010]![SCH_YR]="2005"...

It seems to slow it down a little, but it works, thanks again..

Lookup table... Thanks for the help

Yes, just the 5 numbers.

I have a query that contains a field with 4 codes that I need to replace with values. Example: Replace([CE020]![LNCH_FLG],"0","None") Replace([CE020]![LNCH_FLG],"1","Free") Replace([CE020]![LNCH_FLG],"2","Reduced") Replace([CE020]![LNCH_FLG],"3","State Free") Replace([CE020]![LNCH_FLG],"4","...

BUMp Bump Bump

I was hoping that would catch someone's attention!! :D

Hello All, I'm using this Code to have a query pipe/export its results out to an excel spreadsheet. And it works great! Sub export_to_excel() Dim mfile myfile = "Your path name/spreadsheet name.xls" DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "your query name", myfile End Sub...

thanks alot :D

Quick Question: I am developing a query and I want to have the user input a value (ie criteria). How do I do this? Basically, when the query is run, small windows pops up and ask you to enter a value. I've seen it before, I can't recall how it works.. And help would be great.. thanks, pete

I had no luck searching for this, maybe I could get some help. I have a column, which contains values of "A" and "T", I need to have a count of all the "A" a "T" records. I have no experience with expressions, so any help would be great !! thanx pete