Recent content by Denyial

Thank you for the formatting, forgot about that. But how would I build a query to do that? I feel as if I'd need to use a WHERE [Review Number] = 1 but I keep getting errors.

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...

Sorry it took so long to reply, you've been really helpful plog over this summer with my uselessness, so thank you. N/A ? Or maybe just (nil) ? . What do you think? Thank you!

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 know what a Macro and an append query are, the rest are lost on me I'm afraid, what do you mean?

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...

Lol Plog answered it for me, OK I'll see if I can work with that, thank you!!!

The companies (corresponding to the numbers) can perform multiple roles (Civil or Structural Engineer Consultants, or contractors in their own right etc) for a variety of projects (A,B etc). Each record corresponds to a different project, with the various companies fulfilling the various roles...

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...

Here's what I've done so far. Sorry for being a useless newbie, got set a job and am woefully bad at this.

I am aware it's probably too late for you, but you've been just so darned helpful. Can I still send it to you?

OK when I run it without TestProject, I get the list of Company IDs, all the Percentages are blank.

Probably should have cropped that.. oh well.

OK, first off thank you so much for being the first person ever on an advice forum to give a clear and non-patronising answer, seriously thank you! Did everything, got a blank table as the result... https://imgur.com/F19oaIP

That might not have been as helpful as I envisaged. Sorry.