In spite of all the Access reports, etc I've done, I still find the topic of where to place a formula to be confusing. I can't find a pattern or commonality to tell me. Do you put the formula for sum or count, etc in the header, footer,or detail or in the group header or group footer you have...
I have a DB which includes customer names. One report runs an alphabetical list from A on page 1 to Z on the last page of ALL customers. It also counts in 2 ways for the customers. For example for the last name Adams it will list all of the Adams then all Arsten's. It will give a running count...
We are trying to importing data from an Access 2000 table into the contacts in Outlook-why reinvent the wheel when we have the info we need.
The problem: it imports only the data from one (the 2nd) column into contacts and not the other fields
??
We are trying to impoting data from an Access 200 table into the contacts in Outlook-why reinvent the wheel when we have the info we need.
The problem: it imports only the data from one (the 2nd) column into contacts and not the other fields
??
We commonly use queries (and the same ones in reports) that prompt for user input and return the results based on the answer. The problem is when there may be more than one answer desired. An example- The query prompts for "What is your favorite fruit?" The answer might be apple, but it may be...
I have a rather simple A2000 database-one table (not linked), a couple of queries, a couple of forms, no reports and a couple of macros
After finishing I tried to create an MDE file so no one could moify the orig. file. The utility runs for a while and then generates an error which I checked...
I have a rather simple A2000 database-one table (not linked), a couple of queries, a couple of forms, no reports and a couple of macros
After finishing I tried to create an MDE file so no one could moify the orig. file. The utility runs for a while and then generates an error which I checked...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.