Search results

I have a simple table holding a list of legal defence firms that we use at court. Each name has an autonumber ID assigned. When I try to create a report sorted by defence firm, I get the ID number instead of the firm name. This is no good - the report will be summarizing the time it takes to...

I'm working on a small database to track criminal cases by court location. We have 7 court locations, each with their own set of defence solicitors. In the main input form, i have fields for court location and defence firm. Both of these are based on tables. I want the court location chosen to...

I want to set up a report menu that allows users to choose only those records relevant to the current week, or the following week. So, for example, if the user chooses to run a report on a tuesday to show records for the week commencing the following Monday, the report will ignore all data for...

I need some help please. I have a simple db that generated reports about trials in our courts. The reports used a query to work out if the trial was unsucessful or vacted and relisted for a later date. These worked well. Now they don't work, and when I try to rebuild them using the report...