Ask Your Question

Base report data field formula for 2 tables [closed]

asked 2017-10-21 18:47:03 +0200

Michele Salvador gravatar image

I have a database with two tables:

  • "Friends" (Name, CountryID)
  • "Countries" (ID, Country)

I want to build a report displaying a list of friends names and relative country (USA, Italy, France...) instead of country ID.

Which formula I have to use in Data field of "Country" Text Box properties?
Is SQL allowed?
I tried SELECT "Country" FROM "Friends" JOIN "Countries" ON "ID" = "CountryID" but it doesn't display anything in the report ☹

Thank you!

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-10-18 16:41:59.591124

1 Answer

Sort by » oldest newest most voted

answered 2017-10-21 18:56:30 +0200

Ratslinger gravatar image


Report builder only allows one input for data: table or query. You need to create a query resulting in all information needed for your report based upon the two tables and then use that as input to the Report Builder.

Report Builder does allow for creation of fields based upon other fields such as calculated totals and others.

edit flag offensive delete link more


Thanks a lot! This solved my problem 😄

Michele Salvador gravatar imageMichele Salvador ( 2017-10-23 01:50:45 +0200 )edit

Question Tools

1 follower


Asked: 2017-10-21 18:47:03 +0200

Seen: 377 times

Last updated: Oct 21 '17