Recent content by ymalcolm

  1. Y

    selecting sepcific record in report

    I have created a summary report that lists heaps of information for each donor at a charity. Instead of always having to print out the entire list of donors, I would like some mechanism whereby I could prompt the user to select a donor from a drop-down list (or some equivalent functionality)...
  2. Y

    crosstab/parameter queries

    I have tried it both ways, it doesn't seem to make a difference. For the time being I've found a workaround, where I create a make-table query from the original query where I need the information and then apply the parameter to a select query based on the new table, but updating that is going to...
  3. Y

    crosstab/parameter queries

    Just to let all you lovely helpers out there know, I have read every entry on parameter/crosstab queries in the forums and none of them is giving me different results when I implement them in my query, so, here goes: customer_query1 queries three separate tables: customer (for the customer's...
  4. Y

    many to many relationship entered into single field in query

    Before I launch into the detailed description, I've foud a simple way of expressing what I need. But please feel free to read the long bits too: If more than one order # exists for a specific customer, print all order numbers in one field spearated by commas. my database has several tables...
  5. Y

    retrieve all related information for single row in a table

    Before I begin, let me thank all the nice people who have responded to my previous questions - it's been tons of help. By way of explanation, I'm coming to Access application development having previously only worked with MySQL and PHP for web development, and the transition is less smooth than...
  6. Y

    Creating forms with information from multiple tables

    Thanks so much Pat, but after a couple hours of working on it, I figured it out. Now I'm just scanning the forum to figure out how to put the result of a calculated field from a query into a table.
  7. Y

    Creating forms with information from multiple tables

    I have run into a problem which I cannot seem to find an answer to. I am relatively new to Access, so excuse my lack of proper terminology when discussing this problem. I am writing a database to organize a list of funders and the programs they fund (at the most basic level). Most information...
Top Bottom