Search results

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

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

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