Search results

I have 3 fields. FamilySize, IncomeLevel, and Rank. It is based on a Admission Priorities chart like this. The family will get ranked no 1 if family size 2 and income level $364. Or if family size 3 and income level $390. Or if family size 4 and income level $ 433. Or family size 5 and income...

Hello everybody, I have a query (thx very much to Colin :D) that contains parameters and everything. So what I did I make a report out of this query and then I convert it to Excel. My problem is Excel cut the leading 0's on the conversion. So instead of having customer ID of 00121, it shows...

Hello from a newbie :D I would like to do a customer monthly report from last year fiscal year. It starts from July 2001-July 2002. In Dec 25, 2002, I want to report list of customers that are still with us in a particular month. I have Customer table with: CustID, AddDate, and DropDate...

I really would like to print out a report for a simple sign-in sign-out sheet. The report contains name (which the result from a query), time-in, signature, time-out, signature. The question is: But I would like to make it like excel borders and gridlines. All data wrapped in a bordered box...

I am designing a database for a kindergarten. I have a question as a newbie. I'm to record ParentA and ParentB and Child information. I make 3 tables for them respectively. The question is what kind of relationship should I assign to them? I noticed most of the family are single family. So I...

I have two newbie questions. Your help is greatly appreciated :) 1. How do I orgazine all the tables in the relationship window ? My tables are cluttered all over the place that I couldn't even see some of em anymore. 2. I would like to make a report just like this. All of our customers are...

My database is for kindergarten. Is there a way that I can calculate the kids' age from their date of birth field? I have tried using the datediff function, however I want it to be exact like 1.3 (1 year and 3 months old). Many thanks :)