Help With Music Database

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
+----------------------------------------------------------------
 
D

DNF Karran

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
+----------------------------------------------------------------
 
D

DNF Karran

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
+----------------------------------------------------------------
 
I

integra

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
 
I

integra

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
 
D

DNF Karran

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Choose fields on a form for export report (table base) 1
Where's my music? 4
redo coding. 4
How do I fade music tracks in power Point Presentation? 1
help with a Query Expression (Builder) 1
How do I email a PowerPoint slide show with music? 2
Default Value option 1
Adding music tracks to a CD 2

Top