Search results

I have the following source data: Item Revision Start End 332 B 9/2/11 9/15/11 332 C 9/21/11 9/22/11 332 E 11/2/12 11/29/12 2A9 A 1/13/13 1/14/13 2A9 C 1/16/13 1/18/13 I'm trying to make a select query to provide the following output...

As many of you are likely aware, Access has a [Select TOP] feature but does not have a [Select BOTTOM] feature. Very annoying. The work around I used had a query which sorted a field in descending order [ORDER BY table.Field DESC], and another query which used a [Select Top 10] and a [ORDER BY...

Is it possible to place controls on top (in front) of subforms in Access. If so, how is this done? I have a main form and a subform. I would like to give the illusion that a FEW of the form controls are actually part of the subform, but the rest of the subform controls should appear...

Background: I have a form and 2 subforms - subform1 is a pivotchart and subform2 is a datasheet generated by a query. I would like to filter the results of the datasheet based on fieldbuttons selected in the pivotchart. Discussion: I have accomplished similar tasks using a syntax similar to...

I want to build a query using data from sheet 1 of the attachment for the purpose of building either a chart like in chart 4 of the attachment, or a pivot chart. This chart shows a running sum of items per employee for the most recent 30 days. Ideally I could make a pivot chart to filter data by...

I'm sure this is a simple issue, but I don't know what terms to search for. I want to display all fields and records from tbl_Document that meet the criteria specified from qry_Documents. I'm trying to do this using a WHERE statement, but every time I run the query I'm asked to provide a value...

I have a VBA query building function that works well for sorting information from TableA. However, I also have various link tables TableB and TableC that are associated with TableA. Data from TableB and TableC is entered and displayed in subforms within the main form that pulls data from TableA...

I'm using Access 2003 and trying to make a chart that displays data as 4 columns, 2 lines, and x-axis by month. I actually managed to get all this data into a chart, but the limitation I'm hitting in Access is that I can't just have 2 lines and 4 columns on the chart. :confused: Datasets A & B...

Hi, This is my first post, and I'm still new to Access (although not databases.) I'm working with the table below: MonthOpen ---- MonthClosed 4-2011 ---- 7-2011 4-2011 ---- 6-2011 4-2011 ---- 6-2011 4-2011 ---- 5-2011 ---- 7-2011 4-2011 ---- 5-2011 ---- 5-2011 5-2011 ---- 6-2011 5-2011...