Recent content by BlueCarpet

Perhaps last was the incorrect expression to use; Suppose I had a field of data like such....... 1 Aug AD123 Mr Smith 45 1 Aug AD124 Mr Jones 34 1 Aug AD161 Mr Johns 45 3 Aug AD123 Mr Smith 34 How could I set up a query such that I can specify that given today (3...

Thanks for the advice. I am still having trouble isolating only the last Entry of the Field that I want to search for. I am currently rebuilding the database to make sure that there is another ID field to search under (maybe so I can use the DLookup function) but at the moment I am still...

HI, I have been reading the many postings on the PrevRecVal function and it seems to be the one I need to use for some calculcations. However, much of the discussion concerns its use in forms or reports, is it possible to use the function in a table. I have a database of entries of financial...

Hugely appreciated. Thanks for all the advice regarding Access, it will certainly be noted!

I am posting the database. The table concerned is the only one in there. Basically, I need to group the records by GFICODE. Following that, I need the averages of the BID and OFFER fields for the grouped records. All other fields ought to be identical by GFICODE (there are a couple of exceptions...

This looks promising. I have tried some simple statements in SQLview however I keep coming up with some errors. Am I going to have to do this by Macro? In which case, does anyone have any pointers as to how to structure the problem.

Hi, I originally posted this problem on the Tables forum but having read a little bit more about Access, I think that perhaps I am looking at some kind of Macro using the RecordSet functions. "Suppose I have someone who writes an exam 10 times in one day. However, it is only the last result of...

I think the way I phrased the problem is confusing. Let me try again. Suppose I have someone who writes an exam 10 times in one day. However, it is only the last result of that day I am interested in, not the preceding nine. When the information is entered into a spreadsheet, it will have the...

Hi, I am new to Access and I was wondering whether it is possbile to carry out the following operation in Access. I have a Table that contains several hunder records and is updated every day by file transfer. Now this table mayh contain several records for the same unique ID, so for example, ID...