Search results

I have a dataset that looks like this: Cohort Review Number Average Score 1 1 2.39 1 2 4.55 2 1 2.62 2 2 3 I want to run a query that finds the percentage difference between reviews per cohort...

I am using this field for a query: Win Percentage: (IIf([ContractorNumbers] Is Null,0,[ContractorNumbers]))/(IIf([ContractorNumbers] Is Null,0,[ContractorNumbers])+IIf([BidderNumbers] Is Null,0,[BidderNumbers]))*100 Where [ContractorNumbers], [BidderNumbers] are both fields from other...

I'm an utter noob at this but I was wondering if you guys could help me out. I have two tables (see attached) Copy of Example Query Results is a copy of the table produced by a separate query (didn't bother to show). I want to be able to make it so that the Select Query I made to produce this...

I've got this example data-set (see attached) where each number corresponds to the primary key in another table, each number being a company name (not really relevant). What I want to be able to do is: 1. Produce a query table result with the Total Project Value (sum of all values) each...

I currently have two tables. One with a company list with related information on each company. The other, with projects and related information on each project. Table 1's field headers are: Company Name | Percentage Table 2's are: Project Name | Stage | Contractor | Bidder where under...

I posted a question yesterday however realised in hindsight that I wasn't particularly clear with what I needed help with. I am looking to input data from two text boxes on a form, indicating a price range and have a query show all records with values between those numerical values. Normally I...

Hi, absolutely brand new to Access. I am trying to set up a query by form with multiple criteria. For the majority of the criteria I'm using the format: Like [Form]![formName].[txtInputboxName] &"*" . I copied the Like (...) &"*" from someone else in order to allow for multiple, optional...