Exporting the last record

[ibbledibble]

How do I write a query to export the last record from my database? I can run a query to export the whole dataset into an excel file - no problem - but we only want to export the last record in order to email it to a different office.

The dataset consists of five different related tables with different fields.

Then when it is received by the other office, they can import it by using a macro to select the different excel ranges to append them to the relevant tables.

 

[ibbledibble]

Actually I've put this question incorrectly. I think it would need to be the record you are currently working on i.e. the one open on the screen in front of you.

I have a headache.

 

[ibbledibble]

Ok, let me try again. Maybe I'm going completely the wrong way about this and am leading myself up the garden path.

We have a service that uses an identical database in three different offices. They are not connected by servers.

We receive referrals into the head office that will enter the case details onto their database. The database consists of the following tables:

Customers
Incidents
Actions
Outcomes

When the initial referral is entered, the head office will have details in the Customers, Incidents and Actions field. I then want to export and email this record to one of the outlying offices that will carry on with the case. Obviously the outlying office will need to import the record into their database.

So, the situation will arise where the outlying office will be working on numerous cases referred from the head office. When the outlying office has done all they can on one case, they will then need to export and email that specific case back to the head office.

I hope this is clear, I really look forward to someone enlightening me

 

[ibbledibble]

No answer

Is this problem just too bizarre it's unexplainable or just too simple it's been left to everyone else?

 

[Rabbie]

No answer

Is this problem just too bizarre it's unexplainable or just too simple it's been left to everyone else?

No its just I don't have the time or inclination to work out what you actually want. However if you have a date/timestamp on each record it is easy to pickup the latest record.

Try looking up the MAX and DMAX functions in Access Help

 

[ibbledibble]

Well don't bother replying then, maybe someone else can help me.

 

[Rabbie]

Well don't bother replying then, maybe someone else can help me.

I have given you the suggestion of looking at using the MAX function. You might also benefit by reading the posts on how to get a reply.

 

[ibbledibble]

Well ok...but you're assuming I know what the MAX function is. I don't. And as I've cobbled together a database from scratch I need a lot of help when it gets to more complicated stuff. If I didn't explain properly in Access speak well, there you go.

 

[Rabbie]

Well ok...but you're assuming I know what the MAX function is. I don't.

Thats why I suggested you look it up in Access Help.

And as I've cobbled together a database from scratch I need a lot of help when it gets to more complicated stuff. If I didn't explain properly in Access speak well, there you go.

From experience the more specific and clear your question is , the more likely you will get a helpful reply.

 

[ibbledibble]

Thats why I suggested you look it up in Access Help.


From experience the more specific and clear your question is , the more likely you will get a helpful reply.

I don't find Access Help the easiest manual to understand but fine, I'll try again. As for clarity, if I don't know the solution I'm not sure how I could be more clear.