Search results

  1. P

    Sorting a concatenate Date and time field

    I have a query that combines a date field and a time field together. When I try to sort that it seems to treat it as a text so that either Jan (1) will be at the top or Sep (9) will be at the top. Is there a way to sort this concatenate field based on earliest or latest?
  2. P

    'On Enter' macro

    I have a text box on form A where a user would enter a number and then press enter. On Enter it would open form B. The query that is the back end of form B is based on the data entered into the text box on form A. However right now when I enter a number in the text box and press 'enter' it will...
  3. P

    One Record creates multiple records

    I have a table (Events) in which I need the action to be: when I create a record in event it automatically creates records on another table (Event_description) based on another table (Event_location). Tables: Event -Event_ID -Event_name Event_location -Location_ID -Location_name...
Back
Top Bottom