Recent content by notfound

Thanks, that's basically what I did. Originally the file had one table for the whole page and no header. I was struggling to get a consistent means of duplicating the info using form fields, bookmarks etc. Headers works fine for this anyway. Thanks, nf

Probably in this case. The repeated info is in a table, but I can put a small table in the header and overlap the table in the main body. I was trying to do it with form fields, bookmarks and cross-refs, but all got a bit tricky cos protecting the file for forms prevents field updates. cheers, nf

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...

Thanks for the reply ajetrumpet, I realised what I was after needed a different approach - I worked out something like: IIF ([TotalTherapySessions]=1,"FirstTherapy","ContinuedTherapy") TotalTherapySessions is always changing for each client, but my monthly stats needs a column counting first...

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...

Thanks for the reply khawar, you've pointed me in the right direction, I'm using Access 2003 SP3 on WinXP. I used the report wizard which generated a list box control for this field. I changed it to text box and it looks right now. Any ideas why this field had a list box? It derives from a...

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...

Thanks again Scooterbug, I knew it should be simple enough.

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...

Thanks folks. I knew about the totals function (sigma button), seems it was the joining function I was missing. I attach a simple .mdb showing my adaptation of this idea. cheers folks!

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...

Belated thanks for this reply Scooterbug! cheers, notfound

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...