Help With Music Database

  • Thread starter Thread starter integra
  • Start date Start date
I

integra

Hi all, hoping you can help me out here. I've only JUST started usin
Access and I've been set the challenge of creating a simple music albu
database.

One of the requirements is that it should be able to add up the numbe
of tracks on each album. This is what i'm stuck on. At the moment
have all the track names in one row (see attachment pic) and I don'
know if i'm able to add them up like that? I know that I'd be able t
easily add them all up if I put them all in the same column but I hav
no idea how I would do that.

Any help is much appreciated! Thanks

+----------------------------------------------------------------
| Attachment filename: scrnshot.jpg
|Download attachment: http://www.MSAccessForum.com.com/forums/attachment.php?postid=217428
+----------------------------------------------------------------
 
Here's my way of tackling this- the report is a little untidy as I hav
just used a wizard and tagged a field to count the fields with data o
the end. I have also added a module containing a function.

I am however possibly not the best person to be attempting this as I a
an excel user so I can write code to solve this but Access may have
built in feature that will get around it!

Anyway, file attache

+----------------------------------------------------------------
| Attachment filename: musicdatabase[1].zip
|Download attachment: http://www.MSAccessForum.com.com/forums/attachment.php?postid=217430
+----------------------------------------------------------------
 
Here's my way of tackling this- the report is a little untidy as I hav
just used a wizard and tagged a field to count the fields with data o
the end. I have also added a module containing a function.

I am however possibly not the best person to be attempting this as I a
an excel user so I can write code to solve this but Access may have
built in feature that will get around it!

Anyway, file attache

+----------------------------------------------------------------
| Attachment filename: musicdatabase[1].zip
|Download attachment: http://www.MSAccessForum.com.com/forums/attachment.php?postid=217430
+----------------------------------------------------------------
 
Hey, thanks for looking! Unfortunately it has to be a query tha
calculates the totals though. Any idea how I would do this? W
haven't got on to modules yet so that kinda went way over my head.

Thanks
 
Hey, thanks for looking! Unfortunately it has to be a query tha
calculates the totals though. Any idea how I would do this? W
haven't got on to modules yet so that kinda went way over my head.

Thanks
 
Me again- Looked at this again for you as I need to improve my acces
skills beyond VBA- which I learnt in xl...

However, I keep hitting dead ends- there appears to be no way to have
table or query field that carries out the kind of calculation you nee
to do. There are ways of doing this through Reports (and probably form
so data could be written to a table) and some are probably more simpl
than I have come up with.

All I can suggest (assuming you get no further replies) is to chec
through old posts and attempt to find if someone has asked a simila
question and been given an answer!

Good luck

Dunca
 
Back
Top