Search results

And i managed to upload my database to rapidshare, too large to make it an attachment (even after removing all pictures, forms, reports, queries, macros and data), but i put it in a .rar and its pretty small now :) http://rapidshare.com/files/243029303/Gym.rar.html

thanks heaps for helping datAdrenaline, yeah my table are a bit weird, started out alright, but then i foresaw problems so i tried to change the tables around, but i think i just made it worse. lol I will try and make the tables the way you said: what do you mean by ProgramDesc though...

Oh yeah PS, when i run it i get the error: Syntax Error (missing operator) in Query Expression "the whole query" then when i click OK it highlights "FROM".

My goals can't really be typed in wrong, they are put in from a combo box which has 3 options, "Lose Weight", "Build Muscle" and "Get Fit", so assigning numbers for these wouldn't really help a whole lot i don't think. all i really want to know is if there is a problem with my code? cause i...

so is everyone saying its not a problem with my code? its a problem with my tables?

So that's my table set up and the 2 actual tables i have data in so far. This is for a school project so i have made up all the data, but didn't think it would be neccessary to put data in the workout and program tables to get this query to work. I basically want this query to be able to...

Hey guys, I am basically trying to show different columns based on information in 1 of my tables. So for example if the data = 1, then show these columns, if it equals 2, show these different columns, if it equals 3 show different ones again. I have been trying to use the IIF() function to do...