3 (I'm sure) obvious questions - Date range, counting hours and deleting unused space

[mattlight]

Hi guys/galls,

Sorry, but I have three unrelated questions, can you help?

1. How do I do a search for, let's say, a year's worth of sales for a tax report but the year starting in April until the following April?

2. To get how many hours within a start and finish time period, I know you can do a sum (FINISH TIME - START TIME), but when totalling a weeks amount of hours I need it to give me a figure like 40 hours. I am getting the result up to 24 hours giving me 16 hours without telling me it's gone around the clock once. Do I have to do Time to text, left(time,2), text to number, and then sum the number or is there an obviously easy way to do it?

3. Is there a way to have a large multi lined field (non-repeating) which is used for a description of a service or product, and if you don't fill the field, when it comes to print the quote, for it delete unused lines and allow the next field to come 2 lines after the end of this paragraph to make it look normal?

Thanks for your help as per usual, I hope you don't mind this questionaire.

[mattlight]

Just one more question please.........

How do I change the (ENTRY) format of a date? I know I can change the display of it but, in UK the date is normally entered DD/MM/YYYY and I can display it as that but have to enter it as MM/DD/YYYY which is so annoying for us Brits!

Thanks again

[LiveOak]

1) The find criteria (without the quotes) is "4/1/2000...4/5/2001"

2) Make your time calculation:

TimeDiff (calculation, number) = (Time2 - Time1)/3600

3) Only when printing or viewing in Preview Mode. There is no way to dynamically shrink a field in Browse Mode. For this use the "Sliding/Printing..." feature in the Format Menu in Layout Mode.

-bd

[DykstrL]

For date entry format, use "Set Use System Formats" in the opening script. This should allow both time and date formats accepted based on what the O/S is set to use.

[mattlight]

Thanks guys, great help!