access sorting data

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

massa - 14 Apr 2008 03:29 GMT

I have three fields in access:
1/31/08 3/31/08 USD 3/31/2008

Fields 1 and 2 contain multiple id numbers which I need to sort and match up
or align the records. Field 3 is the amount as of 3/31/2008. I need to sort
the data in table 1 and 2 and need to reference the updated cost as of
3/31/2008. Can someone help me with this. I am new to access. Thanks

Reply to this Message

DomThePom - 14 Apr 2008 11:44 GMT

Sorry Massa - question not understood - please rephrase and post an example
of your dat and what you are trying to do

> I have three fields in access:
> 1/31/08 3/31/08 USD 3/31/2008
[quoted text clipped - 3 lines]
> the data in table 1 and 2 and need to reference the updated cost as of
> 3/31/2008. Can someone help me with this. I am new to access. Thanks

Reply to this Message

massa - 14 Apr 2008 15:11 GMT

Suppose I have 2 very large excel spreadsheets. One dated 1/22 and the other
dated 3/31. The 3/31 is the updated one. I would like to merge the 2 sheets
and delete the duplicate records. How can I do this?

> Sorry Massa - question not understood - please rephrase and post an example
> of your dat and what you are trying to do
[quoted text clipped - 6 lines]
> > the data in table 1 and 2 and need to reference the updated cost as of
> > 3/31/2008. Can someone help me with this. I am new to access. Thanks

Reply to this Message