Search results

  1. S

    Adding 6 months to a date column

    Hi I'm pretty sure this is fairly simple but just cannot remember how to do it (haven't used access in around 18 months). I have a table that I am starting and have a column called DateFrom that I would like to create an extra column that displays the date in 6 months from that date (not 180...
  2. S

    Select statement to return specific data from another column?

    Hello I was just wondering if this is a possibility to do in one query or if it has to be run from a number of different queries. I am currently developing a database from scratch for work (with very little Access experience). The current query I am trying to run, if linked to a number of...
  3. S

    SQL Help

    Hi I previously added this question to the end of another thread but think it might needs it's own thread. What I am looking to do is pull all of the serial numbers into one column, against the UniqueIdentifier that relates to that serial number. This is the data I am using. SELECT...
  4. S

    Multiple Columns from table into One Column

    Hi I am working with other data that has been created by someone else. There are a number of columns with the same information in (a serial number). What I need to do is get this into one long column so that I can run other queries from it. So far I have tried using this SQL: SELECT...
  5. S

    Query not pulling through all the data?

    Hello I am new to the forum and am a relatively new user of MS Access. I have had to learn for work and have learnt everything so far through online tutorials. I am currently trying to pull a query off from a table that needs to have 3 columns side by side, linking to the same ID number...
Back
Top Bottom