I am obviously not understanding something very basic with regard to Group BY and Max() sql statements. All I want is to return the entry which has the...

I have just created another querry in my database, which has currency values of parts which have been shipped. Previously I didn't have this querry, but now...

Ive posted two questions and i cant find them now so heres goes the 3rd: I have a query and want the blank fields to reflect as zeros. I do this...

I am frustrated with this one... I have a crosstab query used to display results on a graph. I want to filter "risklevel" depending on what is selected in a...

I have a table X that contains person's blood pressure reading dates and sys/dia results. Many may have more than 5 BP readings. I want to return only the...

Hi, Originally I had to use the following formula in a query: Amount_Final: Round(,2) Now I get the following dispaly Amount_Fianl 0

In the below query I want the max year field to pich the associated school that the coach was affiliated with that max year. Currently the query gives the...

Hi Access Gurus, In A2003 I want to write an update query which updates about ten fields at once. The idea is that if any one of these fields is null, I...

How do I round a number to the nearest 5? 121.23 = 120 123.45 = 125 1456.19 = 1455 Any suggestions?

Read a lot of posts but ... One table called Address has field cell and field email. no data in those fields. Second table called Cell has field cell and...

Greetings, I am putting thisinquery because i think I will have to use a query to get my result. I need to export an Accwss 2000 table to mySQL. The table has...

Hey, I have set of queries in access which determine the following: Query1- Group single occurance together. Query2- Group all 2, 4, 6, 8, 10, 12 occurances...

My Table Fields First Middle Last Suffix Need the new field in the qurey Will be FileAs: What is the expression so that FileAs displays Last (space) Suffix (if...

Hi All, How do you update different values in different cells with differnt values?. Thank you in advance. Thank you John

I would like to (as in previous versions) be able to see the "properties" of the query. I have found the only way to see the "properties" is to right click...

Is there an easier equivalent to the "xg_lPad" function in ACCESS 2007" to right-align text in a field when doing a query? That function worked with ACCESS...

ozip dzip shipdate 191 202 1/1/2009 191 203 1/4/2009 222 214 3/1/2009 223 125 3/2/2009 191 202 1/27/2009 i have...

Hello all. Here is my dilemna. I have four reports I am pulling in data for. The data for three of the reports includes Date, Function, User ID, Queu,...

I have a table, 'tbl_data' which has the following fields: UnitNo, Mot1Date, Mot1Hrs, Mot1No,Mot2Date, Mot2Hrs,Mot2No Example Data 123 1/22/2010 2223 1 ...

I'm trying to create a calculated value (ToUREV). Two fields need to be multiplied; CONSUMPTION (from DATANORM) and either OFFRATE, MIDRATE or ONRATE...