Search results for query: *

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

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

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

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