I got a task and see if you can accomblish this. I couldn't accomblish cause it's not like excel.
A column = ID, B column = Name, C column = Donate, D column = Date, E column = Total (date). Task: Pretend that there's 5 record. All record donated as 5, 10, 15, 20, 25. Date are 9/1/11 (3 rows down) and 9/2/11 (2 rows down). On Column E; try to code so that it calculate row C only if row D = 9/1/11.
Hello Richard I was making a database about the audio files with their audio lengths in the column. I want to know can we have a query that would calculate the total length of audio files I have in Hours:Minutes:Second format for that particular CD or Album
thnx so much!
sinsirful 3 months ago
I got a task and see if you can accomblish this. I couldn't accomblish cause it's not like excel.
A column = ID, B column = Name, C column = Donate, D column = Date, E column = Total (date). Task: Pretend that there's 5 record. All record donated as 5, 10, 15, 20, 25. Date are 9/1/11 (3 rows down) and 9/2/11 (2 rows down). On Column E; try to code so that it calculate row C only if row D = 9/1/11.
hangc10 6 months ago
Hello Richard I was making a database about the audio files with their audio lengths in the column. I want to know can we have a query that would calculate the total length of audio files I have in Hours:Minutes:Second format for that particular CD or Album
vishalsarode271 6 months ago in playlist access quick
Very Clear and to the point lesson. Thanks.
rcastler007 7 months ago
thank you for this. very helpful!
rmuadji13 8 months ago
IF ITS 9:30PM EASTERN IN THE US WHAT TIME IS IT IN THE UK?
daveLFCfan2 1 year ago
Thank you!
EdiGeforce 2 years ago
Great Job, Thanks for the tip. How can you do this from mon to friday without doing each day at a time?
jmonn01 3 years ago 2