Hi, I have the following query: SELECT tblValidationMileages.Model, tblValidationMileages.Derivative, tblValidationMileages., tblValidationMileages.,...

Hi guys, I am developing around 15 reports, all of then have a common query, very detail query, and from this query I generate the reports or generate...

Thanks to all that look and assist. I have 1 Table with 3 fields: Number (auto number), Customer, Order number The customers in this table may have anywhere...

Hi, Considering a table/dataset of structure below: Name, Code, Other fields ABC, 1, ........... ABC, 1,............ ABC, 2,............ ABC,...

Hello, Can you please give me advice on how to build a query on the same table twice. In English, I have a table of students. Naturally some of those...

Table 1 Month Month_Num Cost Center Manager Hours_1 Team Leader Oct 10 1234567 J.Peters ...

Here's what the data might look like: ID M MStatus Appl ApplStatus Art ArtStatus Appr ApprStatus -- --- -------------- ----- --------------...

table: users columns: owner, admin, user Query: create a fourth column called type when, admin = 'y' insert a "3" owner = 'y' insert a "2" neither owner or...

I have a one-to-many relationship and want to display the master record and only the LAST sub-table record.

I have a query as follows: Date Amount RunningSum 6/01/06 100 100 6/02/06 150 250 etc. I...

Hello, I have a query where one of the fields has a 10 digit date. It's some UNIX format that represents seconds from the year 1970. Does anyone know of an...

I have a query which I would like to display the 10 quickest swimmers. How can I limit the query to show only 10 records. Secondly, 1 swimmer may have many...

I was interviewed for a job today and they asked a question that baffled me. If you were given a list of 100 names, how would you seperate them into...

I have a query which contains a "Curr_Amount" column that has numbers, a “Prev_Amount " column that has numbers and also a"Difference" column that is...

I have a table of 110k+ records with 25 different user names Here are the field names FName LName GrpNum Date I need a query to create a selection of 10...

I am fairly new to Access but I am trying to generate a listing via a query to get 10% of the items of the query for a physical inventory. The query pulls...

I used the code that was on this group in MS Access but i get the same value in each row for 12moAvg calculated using the code below. I am not able to...

Hello, I can successfully create a 12-month rolling average based upon data in this...

In Access 2002, is there a way to create a 12 month rolling total for monthly information. For example: Month Monthly total ...

All, thanks for the advice to get me this far. previously i had asked about a 12 month rolling total, below is the SQl but for Decembers the total is wrong,...