Search results

I changed everything to EXPRESSION, and it worked!! Thank you so much everyone!!

What do I put instead of 'Group By'?

That worked! ... almost. The problem is that now any duplicate values in my source table (ie a sale made of the same product, on the same store, from the same country) are being removed, so only one is showing. I should have about 100,000 records, but when I run this query it goes down to about...

I'm sorry for being slow, but where do I put those conditions? I was thinking of pulling the rate field out by using a GROUP BY function, where I specify all the conditions that you mention in the Criteria field linked by ANDs -- would that work or is there an easier way? And do I need to do...

Haha, I've already noticed that and changed it to "Currency Type" :)

Okay, I have no clue how to proceed... As before, I want to say: Iif([Currency]='USD', [Revenue]/***The exchange rate given for USD in the month of this record's [Transaction date]***,"") Only now I need the string surrounded by asterisks above to: look down my currency lookup table to the...

Ahh. That sounds good. Let me re-do my table and get back to you if I still can't figure it out.

There are ten different currencies; does this mean I need ten tables? And each data point is valid for one month e.g. January 2015. What implications does this mean for the "CurrencyFrom" field you suggest? How do I format this?

Hi, This query is driving me insane and I'd love some advice. So. I have a column giving a bunch of revenue values in different currencies, and I want to convert them all into GBP. These transactions are also over a period of time, so I need to convert them using the time-appropriate exchange...

That worked!! Thank you so much :)

Hi, Please see attached!!

And do I do any kind of join between the tables?

Hi, Thank you -- but it's still not working! Access asks me to enter parameter value for 'price' and for 'gbp'. I've tried changing the code you wrote so that it says '[Master].[price]' rather than just 'price', but that doesn't help. Any ideas? Thank you!

I tried to do that but Access gave an error with the "A.[price]" and "MasterA" parts -- why are the 'A's there? And there's no Group By in that code -- surely the table it generates will be empty? If you can describe how to do it using Design View I'll be incredibly grateful!

The steps are: 1) Get price (a) from master table 2) Look up price (a) in lookup table (which is called Tier Lookup. Price field is called 'GBP' and tier is called 'Tier'). Round up if necessary. 3) Pull corresponding tier from Tier Lookup. You can ignore Pricing table -- I can pull in the...

Table 1 is called Master, and the price is called 'Price'. Table 2 is called Pricing. The price is called 'list price' and the tier is called 'price tier'. The lookup table is called Tier Lookup, and the field I want to include which corresponds to [Master].[Price] is called 'tier'.

Just to be annoying, are you able to show me how to do that in Design view? Oh -- and I'm using Access 2013.

Hi, I hope you guys can help me with this. (I also hope I can explain it clearly!) So. I have a master database (TABLE 1), and a database that I need to check for accuracy (TABLE 2). One of the things I need to check is price, but Table 2 uses price tiers, whereby the prices from Table 1 are...