Search results

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.

Table 1: --------------------------------------------------------------------------------- | Company ID | Company Name | Percentage | --------------------------------------------------------------------------------- | 305 | Carillion Lafarge...

OK let me set it up, how best to send the example Tables?

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

If box 1 and/or box 2 is not valued, I was hoping that it would return every record possible so that the other criteria (e.g Location, Date etc) would refine the table. If they were both valued, it then outputs the fields corresponding to their range, as well as other criteria listed. For...

I'm sorry I don't understand what you mean. I tried copying the code you sent me into the query criteria box, however I got an 'incorrect syntax' error...