Search results

  1. E

    Summary and detail in same report

    I am recording financial transactions for several different people in a table with the following fields: AwardID (AutoNumber URN) AwardDate AwardTime RecipientID (Reference to recipient's personnel record) DispenserID (Reference to dispenser's personnel record) AwardCatID (Reference to...
  2. E

    Date Format change created by SQL Statement?

    I need to select multiple records from a listbox which is designed to look like a datasheet. I will use the selected records to select records with matching dates in another recordset. A sample selection results in the following SQL statement, as seen the immediate window: SELECT * FROM...
  3. E

    Using a form to update a table

    My database is designed to record Comments made by auditors and Responses to them made by the managers of the units that have been inspected. My process is: Create an Inspection record Record the inspectors' Comments Print a Report of the inspection Await responses by email, text or voice call...
  4. E

    CHR() Function not available

    I have a database in which I am designing a report which includes a name/address block. I am surprised to find that the report does not recognise the Chr() function in the text box control source string "=[Organisation] & Chr(13) & Chr(10) & [Address]..."; designed to insert a CRLF between the...
Back
Top Bottom