Hello,
I have a Access 200 format database that contains contact details and a picture for each record. The contact details are held in one table and the images are held in another as OLE Objects. This database is used to produce passes.
I want to export one record from the dartabase including the picture into a format that can be easily tansferred by email.
I've created a query based on the two tables...
davidwelli
Last Activity: Jan 30 '08, 10:51 AM
Joined: Apr 23 '07
Location:
-
I was being a bit thick :o)
I used the same query created to show every 8th client and changed this to a deletetable query.
This removed my sample survey list from the original list.
Many Thanks for help. -
Thanks Nic, I've got the list containing every 8th row, your code made it so simple.
I think I understand the concept of an OUTER JOIN, in my situation I believe I need a RIGHT OUTER JOIN. I'm using postcode as my joined field but Igetting more records than I orginally started with. Could you point out where I'm going wrong?
...Code:SELECT table1.* FROM table1 RIGHT JOIN table2 ON table1.Postcode = table2.Postcode
Leave a comment:
-
Returning the nth record from a client details table
Hi,
Using MS Access 2003, I have a list client details (firstname, middlename, surname, address1, etc).
I need to generate a new client list that is made up of the 8th record from the original list.
I also need to remove the 8th record from the original list.
So, I should finish with 2 lists
Every 8th record client list
Every other record
The client list... -
Thanks for your help, that's worked just fine.
This is a great siteLeave a comment:
-
Thanks, I've amended the code and it now looks like this
However, this result returned two columns,...Code:UPDATE [testtbl] SET [testtbl].midname = IIf(InStr([firstnames]," "),Mid([firstnames],InStr([firstnames]," ")+1,Len([firstnames])-InStr([firstnames]," ")),Null), [testtbl].[firstnames] = IIf(InStr([firstnames]," "),Left([firstnames],InStr([firstnames]," ")),[firstnames]);
Leave a comment:
-
Thanks for the advice but I'm having trouble inputting the command.
My query is using the Access design view and I set Expression1 to Middle Name and the in the update to field I add from IIF but this returns an error about the statement is missing something
I have also treid using the sql view to input the command but it says there is a problem with the syntax.
I've been using
...Code:UPDATE My test SET
Leave a comment:
-
How to separate the contents of a column in a table
Hello,
Using Access 2003, I have a database that holds names personal details of people. I have a requirement to hold first name and middle names in separate columns.
I would like to search the first name field and as soon as space is found remove the rest of the data to a new column
First Name
Sally Anne
becomes
First Name
Sally
Middle Name... -
Thanks for that, you have solved my problem, I didn't know about the IIF function.
Thanks again...Leave a comment:
-
Problem using calculated expression within Dcount
Hello,
All help is appreciated, I'm struggling with the following.
Using Access 2003 (front end) connecting to Oracle 7 database (back end). I'm trying to create a query in access that will show how many instances of something happens.
Within the query I am using a calculated filed called "registered".Th e syntax is
Registered: DateDiff("w",[date_valid],[timestamp])...
No activity results to display
Leave a comment: