Recent content by SajDGreat

Post your SQL from the query's SQL View. sorry im not advanced i dnt know how to post the sql code or to access the code, the teacher sends the work of to a moderator. can i send the whole database via msn messenger? i also have another question, about passwords were shall i ask that questions...

i tried the formula : - =Sum(Abs([Sunday])) + Sum(Abs([Monday])) + Sum(Abs([Tuesday])) u gave me however im still getting the same error message and need to sort it. even my teacher doesnt understand this. plz help

Hi thanks for all your help, i read that article however i found it too advanced im just an average user and finding it difficult to complete my coursework. is it possible that i could send you my database. because when you are saying it is a design problem i still dont understand it. its urgent...

hi regarding my question above i tried the formula that u told me however it doesnt work- it comes up with an error. first i would lyk to ask that in the formula you sent =Sum(Abs([YourField)) the part where it says ([YourFeild]) means the feilds in my database which will be ticked , e.g...

OH MY GOD YOU LOT ARE STARS FOR REPLYING. ive not got the database its in college but im gonna try it. you dnt no how thank ful i am, even my college teachers struggled to do this hopefully it will work. if not is it ok if i email u ppl back using this forum. wens the best tym that you lot will...

Hi, is there a way (in access 1997) to add up automatically all the yes/no a user has entered. basically i am making a database for a newsagent, and for each day the user wants a paper i click the yes/no for that chosen day. moving on from that i want the database to then calculate the toal...

Access Im not going into much detail. im jus allowing the customer to order one newspaper. so for e.g Mr Smith chooses to order the Star on Mon, tues and sat only. he can only choose one type of newspaper. so i simply use my drop down and find The Star, the price then shows up, so wot i need is...

I agree you should use excel as it is a flat file database and acess is a relational database

I am making a relational database using access for a newsagent for my A Level cursework. The owner has several customers who require a newspaper on different day. So on my table i have made a tick box (Yes/No, Data Type) for days Monday - Sunday. In another table i have the newspaper name with...