Recent content by Sarnie83

  1. S

    Adding 6 months to a date column

    Thanks everyone - plog that was actually really useful to think about!
  2. 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...
  3. S

    Select statement to return specific data from another column?

    Thanks this has worked!! Thanks very much for your time!
  4. S

    Select statement to return specific data from another column?

    sorry just one more question - if i want to include all the information do I just need to put and Like "B1-TX2" and like "C1-TX3"? Or what do I need to put innstead of "and"?
  5. S

    Select statement to return specific data from another column?

    OH MY GOODNESS!! It worked! Thank you so much! It didnt at first until I put the asteriks either side!! Brilliant - thats made my evening (oh dear!!) Thanks again
  6. S

    Select statement to return specific data from another column?

    Is "Like" Access's "Contains" just to check as I think I may have it but I dont think it will work with a union
  7. S

    Select statement to return specific data from another column?

    No, that didn't work but whether thats because its linked to another query or not. Basically if I was to do this in Excel. I would filter on "Host Name" with "Contains A1-TX1" and then a second filter on "Part Descpription" as "Contains A1-TX1". Because all of this data is in one report I...
  8. 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...
  9. S

    SQL Help

    Ooops - just seen that and yess it works! I have added in an ORDER BY 1 at the end and its come back with the results I wanted! Thanks
  10. S

    SQL Help

    The database is something I have inherited from elsewhere, that before has just been used for storage of serial numbers. I am looking to pull this data out into something I can submit to our operations team once the "kit" is handed over. There are several components that make up the kit, each...
  11. 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...
  12. S

    Multiple Columns from table into One Column

    SELECT SM_Cabinet_T.UNIQUEIDENTIFIER, SM_Cabinet_T.A1TX1RECEIVER, SM_Cabinet_T.A1TX1DUPLEXERASSEMBLY, SM_Cabinet_T.A1TX1COMBINER, SM_Cabinet_T.A1TX1TRANSMITTERCHASSIS, SM_Cabinet_T.A1TX1POWERAMPLIFIER1, SM_Cabinet_T.A1TX1POWERAMPLIFIER2, SM_Cabinet_T.A1TX1POWERAMPLIFIER3...
  13. S

    Multiple Columns from table into One Column

    Sorry to be a pain again - but is there a way of putting a column next to the query to show which field it came from originally? So instead of having the fields A1-TX1 POWER AMPLIFIER 1, A1-TX1 POWER AMPLIFIER 2 etc with the serial numbers underneath them. I would like to show it horizontal so...
  14. S

    Multiple Columns from table into One Column

    Yes thats worked - and thank you so much for the guide! Thanks
  15. S

    Multiple Columns from table into One Column

    Thanks for the quick reply Paul. I have taken the spaces out of the field names and rerun the query. It comes up with "Syntax error in query. Incomplete query clause" I am relatively new to Access.....so just for my information, when creating tables, it is better to have no spaces in the...
Back
Top Bottom