Search results

Every month my staff is required to count certain activities that may have been started or completed in that month. There are six start fields and six completed fields. These are only for their benefit to provide answers to an external report that is emailed up the chain of command each...

My cross tab column have exceeded 250. Last month my crosstab worked fine with 244, now with 272 headings it will not. Is this an access limit or can I change. I am using a crosstab query to count as well as identify males and females and two other categories. Any help appreciated.

I know this should be simple for some of you that I read posts from. I need some help with gathering info from a multiple records of the same fields of info for a pedigree report. all animals are put in the same table. I want to be able to see and print lineage. table has these fields...

My daughter has started raising rabbits. She cannot afford the pedigree software. I was hoping I could build a database to print out pedigrees. I created some tables dealing with animal info, breeding info, and litter info. The tracking of litters and breeding easy. The part I cannot figure...

future date calculation on a form I want to be able to calculate a future date based on changing vaiables. I have a form with the following fields: sentence date, release date, expiration date, incarceration in days, incarceration in months. I am projecting a release date of probation. Okay...

out put data from one table to another I believe this is a simple question. I have a main table and several other tables within a database. They all are keyed with the same primary key and are joined together. I want each sub table to list the Last Name and First name from the main table...

I have a table that I want to autopopulate the current date as the default value. Date () works on access 2000. Some users have Access97. When I converted it, this no longer works. Previous forum entries suggest that it is a .dll problem and to open a module and then reference from tools...

I have added a field to a table but it is not listed in my field list on the design view of my form. How do I fix this?

I have a financial subform inside a main form. My main form has a payment begin date. I have a datediff statement to count months between current date and payment begin date. I have these in the footer of the financial subform My date diff looks like: =DateDiff("m",[PFs BEGIN],[TEXT28])...

Hello, I hope the following will explain my dilema. I want to have a calculated control on my form to provide an event date in the future. I already have two types of events that I project a "next event" by using update queries ran by a macro button on the form for updating. Heres the flow of...

Totally in over my head here. I have client management type data base. I am attempting to track their accruing fees to me. I have created a sub form along with a financial table. Any input from any client record goes into this financial table as primay key, date, payment amount. My set fee is...