Search results

Hi Jack :) Thank you for being kind. The case sounds marvelous. I have up to 12 in FamSize. and up to 66 in Ranks. I'm out all day too. I'll give it a go when I'm back in the evening (same time zone). Thank you again, no hurry Jack.

Um Jack... The form doesnt' really work the way I wanted it to be. I think I explained it wrongly. What I wanna do was to have a base from a priority ranking chart. Like Rank 1 FamSize 2 Income $364 Rank 2 FamSize 2 Income $400 so if for example i have a customer with famsize of 2...

Hi Jack Thank you for ur kind help. The form works great. However, for example, if I have a customer with family size:2 and income level of $375 for admission, this customer would rank as no 2 (based on the admission chart). Is there a way that the form would automatically say rank no 2 ...

Hi Jack Thank you for the help. I'm using Access 2002. It seems that the zip file is empty. Can you please kindly attach it again ?

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

Thank you so much Ally And sorry for asking question that's already been answered so many times before. Next time I'll be more careful. Off I go trying the format function from Pat. :)

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

Works wonderfully. Thanks a lot Colin :)

ah silly me. I managed to do it. Sorry for the dumb question. :(

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 :)