Hi
I am having some problems with a windows form I am developing as part of a database application. The form needs to hold an address history for a person.
The main part of the form has bound text boxes etc showing the details of the current record. I have also added a datagridview which is...
Hi
I am trying to create a template in Word which uses an Access query as its data source.
The problem seems to stem from the fact the query uses form data as criteria. If the form data criteria is removed all works well, if it is put back in however, the word document is unable to see the...
Hello All
I am trying to write an update query which will set a field to one of two possible values. The value to be set depends on a string contained in the same table.
For example:
If the string = "String1" or "String2" then the value needs to be: Value1
But if the string = "String3" then...
Hi
I need to create a query to delete repeating rows in a table. I need to keep only the rows which do not have any duplicate entries.
For example if I had the following entries:
A
A
B
C
D
D
I need to be left with just:
B
C
Can anyone offer any ideas?
Thanks.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.