Recent content by msaunders26

Hi everyone, I have been creating Pages using the Design View option for entering data into my database. Everything works well except for one table, which looks like this: Location (Type: Text) - Matches an entry in another table Bidder (Type: Number) - ID of an entry in another table Amount...

Hi everyone, Totally new to Access and have some really simple questions here... thanks in advance for your help. I'm creating a report in Design View because I want to have detailed access to how it will look. Before starting building this report I made sure I built queries that return...

You're absolutely right... sorry I'm new to Access. I've made a new query "SELECT AVG(diff) from [above query]" that works wonderfully. Thanks guys

Sorry, I meant the average of all the values in the diff column. However, I tried your suggestion and still get the same error :( Any ideas?

Hi everyone, I have three tables, set up like this, Auctions: Auction ID, Winner ID # (a Customer ID, as shown below), Price Bids: Auction ID, Customer ID, Price Customers: Customer ID, Name I need to find a query that does this functionality: For each auction (entry in the Auctions table)...

Thanks, Brian!! Works great. Does anyone know how I can also take an average of the diff column? I tried modifying the query by adding "AVG(diff) as average" but I get an error of "Subqueries cannot be used in the expression (AVG([maxf]-[minf]))"

Hi everyone, I am familiar with databases and basic SQL, but never used Access, so your help is greatly appreciated! What I *think* I need to do here is take the results from one query, subtract another query from that, then create a table of the results, so that I can make a chart in a...

Hi Everyone, I am completely new to Access, coming from the web development world, so though I know some concepts I am still clueless when it comes to this :confused: I'm trying to build a form, but before the data is entered into my table I need to ensure that the entry doesn't already exist...