Search results for query: *

my query results in a situation like this: name letter color keith a blue john b green kate c yellow kate c yellowx i don't want to see the row which has 'yellowx'. I want the query to only show me the first row in a group of rows where 'name' & 'letter' are the same. Can...

i have a word mail maerge document with numerous text fields which have been filled in. I want to show thesee in a tabvular format in excel. Can i link the cells?

how can i simply test asp pages on my pc / laptop at home without being connected to the internet?

i have a report, the results of which give (typically)10 rows of data. Each row of the result needs to have a 'tag' manually entered on the end. These should all be in the same field. how can i do this. hope someone can help.

I HAVE ENTRIES IN A FIELD IN A TABLE SUCH AS: 5100V#74853769376 4100#8957984768745 5180#89745967 I WANT TO TRIM THEM FROM THE '#' ONWARDS. I.E. SO THEY READ 5100V 4100 5180 CAN ANYONE HELP?

where can i access a glossary / dictionary of all the keywords that are usuable within microsoft access queries? I often intuitively know a certain query can be done but it takes hours of trawling through help / web to find the right keywords. I often succeed by using function wizard in excel...

i tried ctrl+ but tyhis just moved the cursor to the btm of the table, it didn't 'autofill' any values. In answer to tlbroadbent (MIS), i can add these fields in a query and then try to fill the blanks there. I do have a lot of records and so need to perform the programming as mentioned. The...

I have a table that i have exported into an access database. Many of the cells are blank. I want these cells to have the same value as the nearest non-blank cell above them. e.g. england;london spain;madrid germany;berlin america;newyork ;washington ;dallas would become...

when i output my report to a .txt file, Access puts in random blank lines. I have read that a remedy is to make the line size divisible by 8 but that still doesn't seem to work . perhaps i'm doing it wrong?

when i output my report to a .txt file, Access puts in random blank lines. I have read that a remedy is to make the line size divisible by 8 but that still doesn't seem to work . perhaps i'm doing it wrong?

how can i interrogate a field in a query for a certain character and have any occurences of this replaced by another character?