Recent content by pastorandy

Thanks Skip. That's very good. :o)

Many thanks. All working nicely now! :o)

I read that it could be caused by having a memo field so I changed it to text 255 chars. That worked and the names are now displayed correctly. One further thing, how can i then randomise the results? I used the following in one query that worked. Rnd(Int(Now()*Hymn.hymn_no)-Now()*hymn_no)...

Thanks dhookom. I think this works, except that the hymn_names returned, appear to be in chinese characters. Weird!

Hi I have two tables [Hymn] and [Hymn_usage] and I want to select only the hymns that have a hymn_usage_date of 90 days or more, but also haven't been used within the last 90 days. The problem is - while the query works by selecting only hymns greater than 90 days - a hymn can also appear more...

Hi So i've spent the last few days working on a DB re-design. My main purpose was to be able to get the hymn usage data and check that a hymn hadn't been selected within the last 60 days. The Combo181 [AM1] on my main [Order of Service Form] has a query that pulls the hymn numbers from the...

Hi id AutoNumber service_date date AM_PM Time 'switch', Yes/No field, needs a better name led_by text field. person's name notices text field. person reading the notices childrens_talk text field. person's name. prayer_list memo field. sermon_title...

Hi guys Thanks for the replies. It has become apparent that my DB structure needs to be put right so I can do this properly. I am going to bite the bullet and redo it all. Could you give me a few hints please? I currently have two tables. Could you help putting this into a proper...

Thank you. Yes, I didn't see that last part when I posted. Many thanks once again. Andy

Ok thank you. I'll give it a try and let you know how I get on. :o) Many thanks.

Thank you for this. And yes, you are right, my DB needs to be structured properly. I just couldn't get it to work when I tried using a link table. Anyhow, I'm sorry I didn't make this clear in my post. I actually want the hymn list to include the hymn that was in a service less than 60 days ago...

Hi I am a Pastor of a church and have a database that I am creating to help me plan services much more quickly. I have a small Access 2002 DB that generates an 'order of service' report each week. I enter 4 hymns for the AM service and 4 hymns for the PM service (in the same service_id record...

Works well. Many thanks :)

I have the following that calculates and displays the result in an html input form field called payment_amount <input type="button" class="input-calc" name="plus2" value="Calculate Deposit" onClick="document.calc2.payment_amount.value = parseFloat((document.calc2.total_cost.value) -...

Works a treat JP. Thanks guys.