access course microsoft training

access course microsoft training - Query result

Resolved · Low Priority · Version Standard

Query result

Karen has attended:
Excel Introduction course
Access Introduction course

by - delegate Karen [1 post] (2007 Aug 28 Tue, 16:44) Reply

How can I modify a query result?

Version	Date	Location	Places available	Book	Next place rate:
Access Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Dec 2 Tue	Southwark	3	book now	£210	£215
2007	2008 Dec 5 Fri	Bloomsbury	4	book now	£224	£224
2003	2008 Dec 9 Tue	Bloomsbury	0	FULL
2002/XP	2008 Dec 11 Thu	Tooting	0	FULL
2003	2008 Dec 18 Thu	Bloomsbury	3	book now	£210	£215
2003	2008 Dec 23 Tue	Bayswater	8	book now	£182	£207
Full Schedule: See all 53 Access Intermediate course dates. Bookings currently available until 24th November 2009.

RE: Query result

by - trainer David gold contributer [428 posts] (2007 Sep 5 Wed, 12:40) Reply

Hi Karen

The only way to modify the query result is to change the query. If you are not getting the data you want or you are getting to much data, you need to change the query.

Hope this helps
David

· MS Access Top Tips: Takeaways From Microsoft Access Advanced Training
· Innovation with Microsoft Access
· Reasons to Consider Microsoft Access Training
· Three Myths About Microsoft Access
· Microsoft Access Mistakes to Avoid

Access tip:

Run with the total

Often when creating reports with lists of transactions it can be useful to have a column which totals the transactions as the report progresses.

Using the Sum function gives the total for the whole group, not a running total.

Access provides an easy method of achieving a running total.

Click on the text box containing the data you wish to contain the running total.
Select the Data tab
Click in the Running sum option
Click the down arrow to view three options
Ø No

§ This Item is not a running total

Ø Over Group

§ This Item is a running total which will reset to zero with each new group value

Ø Over All

§ This Item is a running total which will total over the whole report