Search results

Hello all, I have a simple 2 page Word document. Each page needs the same 4 pieces of information inserted at the head of the page. What is the simplest way to have a user enter 4 pieces of info and have both pages display this? thanks, nf

Hello all, I would like to base a report on a crosstab query. The report wizard produces it in this format: Venue1 Venue2 ... Category1 Subcategory1 1 3 Category1 Subcategory2 2 2 Category2 Subcategory1 1 2 Category2 Subcategory2...

Hello all, My database tracks therapy sessions with clients. I am trying to generate summary statistics for each month. The important fields here in my table of sessions are: SessionType (Assessment or Therapy) Attendance (Attended; CancelledByClient; CancelledByMe; DidNotAttend) The stats I...

Hello all, I generated a report (based on a query) that almost works properly. One field shows all possible values, rather than the one in the query: The right venue is highlighted, but why won't it just show the selected text? The venue field in the query is looked up from a table with...

Hello all, I am logging the supervision of counselling staff. Each week, a counsellor meets their supervisor to discuss their client caseload. I need to generate a report that summarises clients discussed in the previous session. I've created a query that pulls all this together. The query...

Hello all, I would like to find the most recent questionnaire score for a client. I see there are various posts related to this on the forum, but mots responses are in SQL - I am trying to do this in Access 2002 query design view. In basic form, I have two main tables - clients and sessions...

Hello all, I'm developing a simple db in Access 2002. It's main function is to track when I see clients, so I have a table of sessions which relates to a table of clients. As I enter a new session on a form, I would like to track how many sessions a client has had. Ideally, this would be...