Search results

I can see my example lost some spaces in the posting. attached small picture of report

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

pedigree or geneology Just for anyones info. I have a working database that will print pedigrees. I can be reached thru private message for details

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

looking for animal pedigree db

thanks, I got it to work using dateAdd to do the months.

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

That took care of the problem. Thankyou!!!!!!!!!!:)

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

What I have is 4 criteria for each record I made combo boxes in a sub form with new calculated controls to be = if No then = 0 otherwise, 25. This gives yes and not required choices weights of 25 (percent) each. I used a similiar control for each criteria and then have a calculated control to...

What I have is 4 criteria for each record I made combo boxes in a sub form with new calculated controls to be = if No then = 0 otherwise, 25. This gives yes and not required choices weights of 25 (percent) each. I used a similiar control for each criteria and then have a calculated control to...

Thanks. I went to the form record source property. A field that I had deleted was still listed. I simply typed my new date field name in its place. There it was. Can I store a calculated control's value on a table. If so how? I have a value from a form that I want in a report, but I don't...

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?

Thanks, I wasn't putting an (=) in my contol box. Also I changed my tab order on my subform footer as it wasn't doing my math. I thought tab order was just the way I manually tabbed thru the form. Seemed to make a difference. I now have a financial tracking table that works:) :) :) :)...

I have saved the article in my favorites for future reference. I admit that I am rather dense and new to this. No matter what syntax I have tried, I get a #NAME? in my subform field when trying to give it the value assigned to the parent form. Do I want to assign it to the form control or...

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