Recent content by Sarnie83

Thanks everyone - plog that was actually really useful to think about!

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...

Thanks this has worked!! Thanks very much for your time!

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"?

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

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

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...

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...

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

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...

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...

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...

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...

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

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...