Access help for a newbie :)

[whitlste]

Good morning guys,

I am looking for advice on a small database project I have going on.

I am collecting data on an date based interval and I want to create a query that gives me the result from calculating the last entry minus the previous entry. I have fields that are NAME and DATE and SCORE. The NAME is repetitive, I have a list of 70 that I use the lookup function for. I want the query to return how much a score has gone up since the last entry per NAME.

Thanks in advance for any help

Regards

Steve

 

[namliam]

1) Name and date are reserved words in access you are ill adviced using them as column names in your tables.
2) Is there any logic to your date interval? I.e. should one always look at "yesterday" to find the previous score or should it be more "the previous entry" either yesterday or 2 weeks ago or a year ago dont matter?

 

[jdraw]

See this by Allen Browne for getting value from another record in same table.

 

[whitlste]

1) Name and date are reserved words in access you are ill adviced using them as column names in your tables.
2) Is there any logic to your date interval? I.e. should one always look at "yesterday" to find the previous score or should it be more "the previous entry" either yesterday or 2 weeks ago or a year ago dont matter?

I know how to look back between set dates or within so many days, as I am the only one who updates this table its relevant to my availability, when I say names I mean the column is in fact called Members, however the date is a date column and auto inputs todays date.

Q2 previous entry

 

[The_Doc_Man]

Steve, you are looking for advice, but in Post #4 you say know know how to look back. Is your problem how to find the previous date? What is it that you need help in doing?

 

[whitlste]

I need help in creating a query (in Access) to find subtract a score from the the previous entry from the latest entry (and one I can understand lol

 

[theDBguy]

I need help in creating a query (in Access) to find subtract a score from the the previous entry from the latest entry (and one I can understand lol

Invariably, this would involve using a subquery, which is explained in the link jdraw provided in Post #3. What specifically do you not understand from that article?

 

[whitlste]

Sorry I haven't read it yet, I have it printed off to go through, but I don't want to not answer people when you have the kindness to answer me

 

[theDBguy]

Sorry I haven't read it yet, I have it printed off to go through, but I don't want to not answer people when you have the kindness to answer me

Hi. Thanks for the clarification. For all you know, you actually understand what Allen was talking about and able to solve the puzzle yourself. Let us know how it goes...