Recent content by TLJ
-
T
Counting date fields in report by date range
I can see my example lost some spaces in the posting. attached small picture of report -
T
Counting date fields in report by date range
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... -
T
geneology or pedigree db
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 -
T
column header error in crosstab query
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. -
T
multiple records contingency report
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... -
T
geneology or pedigree db
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... -
T
Calculating Future Dates
thanks, I got it to work using dateAdd to do the months. -
T
Calculating Future Dates
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... -
T
Output Data To Second Table
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... -
T
Date() not working as a default value
That took care of the problem. Thankyou!!!!!!!!!!:) -
T
Date() not working as a default value
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... -
T
field list will not update when adding field to table
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... -
T
field list will not update when adding field to table
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...