Search results

The query option sounds the best way to go about it, so i designed a new query, but i don't know how to sum the charges. I used the sum function (in the total row), but it made no difference. It still displayed all the different charges. Any ideas? If this explaination doesn't help i can email...

try explaining that again... i can't work out what you're trying to do.

I have a report which i need to display one record for each customer (even when they have made multiple entries) which has a sum of the amount they owe. eg, if a person orders a pair of boots one week, it goes down in the charges as a new charge, then if they order a jacket, that goes down as...

Is there a way to make a button that searches in a specific field each time the button is clicked. This can be in the normal access search, as long as it automatically searches in that field. example: I have a form with a number of fields in, and i might be adding data in any of these fields...

Thanks for your help everyone. I'll try them out, and see what i come up with. Tim Stevenson

I have a query, which searches through a table to find information , as queries do. The problem for me however, is that i need the criteria for the query to come from a form. The query will be run as part of the opening of the said form. (the query is where the information for a subtable in the...

ok. this looks good. i am using a form, but not in the right way. i have a table, but i was kinda expecting to have to change it to an excel table, because thats what excel is 4. could you explain event of the control because even tho i do know a bit about access, i've never had 2 use Event of...

I need to have a link between a check boxes in a form, and a excel type table (but not nessacerily in excel). I have a list of people in a form ( a page for each person), which has a check box for different items that they can sign out next to the name, so if they take an item out of the store...

I need to have a link between a check boxes in a form, and a excel type table (but not nessacerily in excel). I have a list of people in table, and a form which has a page for each person, which has a check box for different items that they can sign out next to the name, so if they take an item...