Search results

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

worked like a champ... thanks

I need a little help with a Delete Query. I want to delete all of the records with no value, I created the query, selected the Field and enter Null as my criteria. The problem is that it deletes all of the records, not just the empty ones. any help would be great.. thanks pete

thanks stephen, the Update Query works great..

I have a quick question about populating many records with the same data. Is there any way to populate many records with same data? I have one column in a table that needs the same information copied to each record. I will be exporting this to Excell for conversion in to another database. I...