Search results

Having worked with VBA for a few months I've now set myself the task of cleaning up a lot of messy code I wrote a long time ago. All my subs and functions are in one module and I want to structure them more neatly. This means separating them out into groups, putting them in different modules and...

Hi. I have a query I've built that produces three fields: Rank - 1, 2, 3 4 etc (sorted in descending order) ID1 - an identifier of a person, with duplicates ID2 - an identifer of a second person, with duplicates From this query I want to write a second query that selects both the first two...

Hi all. I'm trying (the operative word!) to build a query for an Access tennis database that is provided and updated by a third party. The query will be based on a table of historic match results that has the Date, the Winning Player and the Losing Player. The query needs to assign a fixed...

Hi. I have a database of tennis matches for which I've built a query that gives me columns for the player's name, the number of times a first serve was won and the number of first serves that were 'called in'. As the query originally pulled all the matches and thus duplicated each player's name...

Hi there, Very new to Access and feeling my way around it. I've successfully created one query off a table that manipulates some of the data (creates a new column from a portion of a string in a field) and then another query that uses data from the table and the other query. However, I'm...

Hi, 　 A colleague of mine who's since left my company developed a reasonably complex Access DB for me to use. I've been quite happily using this on my machine which is a good spec HP running Access 2003. I've recently tried transferring the DB onto a few other peoples' machines with mixed...