I don't know if this should go here or in the Software Col.; if it doesn't belong here I'm sorry!<P>Alright, so I'm relatively new to Access and SQL Server although I have a good deal of general SQL ...

I've got a SQL Query in Access 2003 that returns a series of values. I'd like to dump ALL of the records except the very top one. I thought initially it'd be easiest to "rank" them and then create a ...

A Query is a tool that retrieves data from a single table or multiple tables; it is the most powerful tool to analyze your data in Microsoft Access; Basically, a Query is just a question presented in ...

You don’t need an expertise in SQL to limit the number of records in a group. With your user knowledge of queries and reports, you have all the expertise you need. Grouping records in Access is easy, ...

There’s no built-in way to generate a running total in your Access queries, but you can still get the job done if you set up your table correctly and build the right expression. Database expert Susan ...