Search results for query: *

Skip Thanks "Looks like I Could not see the wood for the trees" Works a treat. S.Eke

I'm using the following to obtain a date range of records Sum(IIf([ACDateRec] Between [Forms]![frmDiaryMain]![UBDATESTART] And [Forms]![frmDiaryMain]![UBDATEEND],[GROSSTOTAL],0)) However the search fails to find all records between dates. I wish to change the above so rather than use Between...

Skip Thanks Working as wished. Now I can sleep. Thanks again S.Eke

Table: Account Fields: CompanyName, InvoiceDate, InvoiceAmount, Status Status will = 3 ie Invoiced I need a query that will produce the following from the above data in colums. col 1. Company name col 2. Toatal amount owed by each company col 3. Toatal amount owed from a date + 30 days col 4...

Download PHPDEV its easy to setup and use

If your starting off from scratch. I would download one of two free programs. IBSERVER or PHPDEV both will set up a windows XP machine with Apache, PHP, Mysql ect. PHPDEV is what I would start with in your case. Also you dont need two machines. I would give you the links for the software sites...

Thank You Roy Now works as I wished. Now I can sleep.

I Have a table called tblWorkSheet within a field called GROSS for the Gross amount, also a field called WACTIONDATE the date of the transaction. A field called WSTATUS has two values Paid or Unpaid. I use a Select Query to find the Gross Total for each month using: JAN...

Now we all know why the legal profession make so much money if it takes 7 mins you get billed for 12. I think i will use the same method when I send his bill. Seke

Omega36 & Missingling Thanks for your input, time & help Found the answer: Me!result = (Me!min + IIf(Me!min Mod 6 > 0, (6 - Me!min Mod 6), 0)) / 6 Again thanks Seke

thank you Omega36. I had the same idea but it only works in part. example If you enter 13 min it rounds down to 12. 2 x 6 min units where I need it to always round up. So 13 min sould be 3 x 6 min units 18 min. Thanks for the idea anyway

Create a lost focus event on your search field text box calling your search button sub. when you tab out or press enter it will call your search button sub.

I'm making a database which is for time billing. a billing unit is 6 min. So if the total time taken is 15 min this would be rounded up to 18 min or 3 x 6 min units. The 15 min would be entered in one field. The number of rounded units to appear in a second field on tab out of first. I thank...

Access XP A form opens with a list box. I use up, down arrow keys to select an item from the list. When item highlighted in list I wish to select the item with the ENTER key, which will send this item to a second form and close the list box form. The aim is not to use Click, Dbl Click or...