Search results

It is ok but comes with a -ve sign How can I get rid of the -ve sign in front of the numbers. In other words make them positive numbers. thnaks

What does that mean Mile-o-Phile? I don't understand much about database. Can you explain please?

Didn't quite get the result. It worked only for the first field, for the rest it was Yes or No. There were no numbers for the other three fields. Any suggestions?

I hava table named tblPeople with the following fields: Id Primary Key Name Tea......checkbox Coffee.....checkbox Water.....checkbox Juice.....checkbox I would like to have a query which will tell me how many times each item is ticked. One person can tick more than one check-box. I can...

Thanks John I shall try that now.....this time I did follow you.

Sorry, but I couldn't follow that...I am a bit daft I guess. Would you kindly explain it in a bit more detail....Thanks

Thank you Tim you are just superb......my problem is finally solved

I have a primary key with autonumber in my main table . I want Access 2000 to start the numbers from 1 but it always starts from some other number except 1. This is so annoying. I have tried deleting the CustomerId and putting it back in.....but of no avail. Please can you suggest something to...

Please somebody help me with this problem as I must finish this by tonight. I cannot create a report which doesn't print the check boxes that are not ticked. Many thanks.

This idea did not work, I must be doing something wrong...can you elaborate please. The report is still showing all fields !!!

I have 10 commenst on my form and the user can click as many. When the report is produced I would like only the checked expressions to appear. Is it possible to do that? At the moment evrything on the form is appearing on the report. Please help me.

Is there anyway I can have several sections in the form to give me totals of subsections? I wanted to have small sections with its own subsections and their totals. Is that possible?

how can I email the contents of each individual form, to the respective person? Any suggestions?

I tried that but did not work. I have access 2000, does that help?

I have added a hyperlink on my form called "email"which when clicked, should go to the hotmail sign in page............it doesn't work. No matter what web address i type in, the link does not work. Can you help me please?:(

well, the main form will display only the chosen comments. Say that I am marking student A, in the "general comments" box there is a link to subform which has all comments. If I choose say, 1.good, 2.well done and 3.be careful about spelling, then only these 3 should only be displayed in the...

I have a box in my main form called "standard comments" and I want user to choose as many comments as they want from a sub-form connected to it. Example, the sub-form may have a check box next to each comment, and when the user ticks these checkboxes the chosen comments are all displayed in the...

Great, thank u very very much.

I am using Access 2000.

Got your point ! Thanks