Search results

I'd like to create a spreadsheet that feeds from access table/query directly and automatically. I update the table and then open an excel spreadsheet, all the fields get updated automatically and current data shown. That's how I would like to work. What is the best way to do it? Thanks.

I tried to find the answer to this, I think simple for expert, question on the forum but coudn't. A report is created from query. I would like just sum up each of two columns with numbers. Which fuction I should use? (they called H and O btw) Thank you in advance

=[Surname] & ", " & [First Name] This is a field in a form in header. What to do to have surname displayed always in CAPITALS? Thanks.

I have main table with 2-field primary key (ID and Programme). I'd like to use update query to update 3 fields from other table. These 3 fields will be changing once a while. I created Update Query per Access Help however it doesn't update anything. Any help? Cheers

How to create control in form header that allows to send e-mail with one click using address in current record view? Thank you.

while clicking hyperlink which take me to word document I take this message, how to get rid of it?

having database full of names and info, how to create a letter which feeds from specific database records with one click, so it can be printed and post it? cheers

having database full of names and info, how to create a letter which feeds from specific database records with one click, so it can be printed and post it? cheers

Hi, I have to tables. In both are names, some duplicate, some ginuine. When I run query choosing just a name column from each table, it doesn't return all names. It just give me duplicate ones. How to have all names included in the query list? Cheers

Hi, I'm fairly new to Access. I have few questions. How to set up database so it searches through my table, finds the name and inputs it into letter in a space I want? Where does this letter suppose to be located in the file? Thank you IOI