Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

queries access

ResolvedVersion 2007

Alex has attended:
Access Intermediate course
Access VBA course

Queries in Access

Is it possible to create a total column (by CustomerID) in a query of another column without the data being grouped? The DealID is unique.
i.e.
CustomerID/DealID/Value/Total
1 a 10 40
2 b 20 60
1 c 30 40
2 d 40 60

If this is not clear please let me know.

Thanks
Alex

RE: Queries in Access

Hi Alex

Thanks for your question

Having looked over your requirements, I am slightly unsure as to how you see this query being laid out.
As the data isn't to be grouped would envisage the totals being repeated on each line for the relevant customer?

Thanks

Stephen

Access tip:

Change The Default Font in Access 2003

You can change the default font in Access 2003 so that whenever you create a new database your preferred font is automatically set.

To change the default font:

1.From the menu bar select Tools.
2.Click Options.
3.Go to the Datasheet tab:
4.In the Default font section select your preferred font from the list of fonts e.g. Arial.
5.Select your preferred size from the size menu e.g. 12.
6.Click Apply.

Click on the Tables/queries tab:
1.In the Query Design font section select your preferred font from the list of fonts e.g. Arial.
2.Select your preferred size from the size menu e.g. 12.
3.Click Apply.
4.Click OK.

The default font for Access has now been changed.

View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.