Search results

  1. T

    Formatting a field in an access query

    I find the properties option can be unreliable. I would try this... int([YourField])
  2. T

    Setting field formats for linked tables

    Had this problem a few times! It sounds exactly as DCrake says. Just put an apostrophe before the value in the first cell of the offending column in the spreadsheet. (e.g. '1234 instead of 1234). Access should then recognise that and all successive cells in the column as alphanumeric.
  3. T

    Staggered Rows into One

    Im having difficulty grouping an output of a query so the data appears in one row. The data shows dates/times of when certain actions occurred to an IT request ticket. Perhaps I should show you what I mean. Currently my output looks something like this: TicketID; Added...
Back
Top Bottom