Search results

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

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

Thank you all for your replies. And thank you! The Cross tab Query is exaactly what I was looking for!! Sorry, I am very new to Access and sort of teaching myself as I go along at the moment. That's amazing thank you!

I've attached a file of what the data looks like and how I would like it laid out as it's easier for me to explain! I am trying to pull the data through so that each individual Site ID has all the different antenna types on one line! Thanks

The table name is SM_Planet_Report_LT and from that I have pulled Site ID, Sector ID and Electrical DT I have made these into three seperate queries. The data in the field "Sector ID" is either DL-1, DL-2 or DL-3, so have seperated these into the three different queries. What I am trying...

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