Search results

I have a continuous form that lists Academic Progress for medical students as well as hospital residents. I'd like to make it so that certain fields (such as "Program") only appear as visible when another (Status) field lists one of four things (such as Resident). I want the visibility of the...

Hi, I was wondering if anyone knows how to extract numbers from a text string. I have a notes field that often has year information somewhere in the midst of text, and I want to extract all numbers, but no other characters, from that field. Are there any functions/expressions I can use to...

I have a query that uses three tables, and a form based upon it that is very complicated, multi-tabbed and sub-formed. The form was running quickly and smoothly until one day I decided to try adding a table to the main form's query, and calculating the number of entries in that table per each...

In my database there is a field for notes which is stored in its own table, called "Notes." This table is accessed from a subform, accessed from a tab, which lists all notes for a particular person. Not everyone has notes, however, and there's no way of knowing whether someone has them without...

This is my dilemma: I'm working on an Access 97 dabase of medical residents, with one table for identification linked in a one-to-many relationship to another with multiple records for each year of residency. I want a query that generates a list of everyone who ever served a residency at a...