Search results

Hi Paul, Thanks for your quick response, do you know how this would be achieved using the design view as I am not fully up on my sql? Cheers Barry

Hi I have an access table which has a key using letters (A,B,C,D...etc). Against each letter there is multiple rows against each letter. However for testing purposes I only need to get a single row against each key and I was wondering if there is a function I could use which would return...

Hi Paul, thanks for your help. I tried that function but it didnt quite return the data concatenated the way i was hoping for as there is loads of blanks which are sporadic throughout the cells and many in the first cell. I tried this function but again it as given me a syntax error (comma) in...

Hi I am doing a concatenation query in access using Builder. when I run my query it brings back a cell with just the ;; in it as the row before obviously doesnt have any data in it. I want to incorporate an iif function and to look at if the cell before is null then don't include in the...

Thanks jDraw,Cj_London has summarised it. I am looking at when the square brackets, round brakets, full stop, commas are used etc. and basic language when writing queries like the use of FROM or ELSE, this type of thing.

I am used to running queries in access using the design view but want more of an understanding of sql so i can write more complex queries. I have a good understanding (not expert) of design builder but is there a good fundamental flow/structure i should understand when in sql mode? Any advice...

Paul, sorry to be a pain. I have just one table now instead of two separate tables. Would this be the same function with the exception of the FROM table text at the end?

Thank you Paul, that worked perfectly. I am upskilling myself in the builder module so I really appreciate your help. Cheers Barry :)

Hi have a table in Access 2010 and in one field i have multiple records of the same data as in the next field it has unique data for example: Name Colour Car Blue Car Green Car Yellow Bus Orange Bus Purple Bus Red I am trying to run a query which will effectively group up the "Name" field and...