Search results

Ideally want something like this that I can edit....you can see I've a lot of data to enter and I just want to see it clearly

Should have said the crosstab query looks something like: xxxxxxx 4000 Training 5000 Expenses Jan 2021 Feb 2021 Mar 2021 Etc..

Hello, I have a table for an annual budget that requires me to enter 360+ amounts for various budget codes. A crosstab query displays the information perfectly and will be great to use for display purposes, however does anyone know how I can make a similar layout for data entry on a form? Cheers

Out of interest.....if I add a new budget code if I run the same query but as an Update query will it then add the new budget code into tblBudget?

Thanks very much arnelgp. It wasn't appending the budget code, but I changed this in tblBudget to short text instead of a lookup field and it now works perfectly. Thank you so much!

Hello! I have tblCodes this has budget codes in (about 20 records) I have tblBudget this has 3 fields (Date, Budget Code, Budget) I need to create an append query so that I can add a new years budget to tblBudget using the budget codes from tblCodes, my problem is that I need to add a month...

Thanks for this, worked a treat....not sure where I was going wrong, but all good now, thank you

I understand that but I could potentially end up with over 20 currencies over the next couple of years and so therefore I would have to autopopulate a whole new set of currencies each month. Also the main tbl uses the Currency tbl as a lookup for the list of currencies

I'm not sure I understand. I have one tbl with a list of currencies in and then each month I enter an exchange rate in the column next to the currency In the other tbl I have many fields (including date, description, budget code, etc... and currency and exchange rate) I need an update query...

I get that, but we just use a set exchange rate for the whole month. Therefore my thinking was I just change the exchange rate for each currency in tblCurrency then use an update query to update tblExpenses (via a query with time criteria) so it then just updates the particular exchange rate...

I should have said that the exchange rates are set at the end of the month and so cannot update them as I add new records, hence need query to run this

Hello!! So I've two tables: 1. tblExpenses 2. tblCurrency tblExpenses has a currency field which it looks up the value from tblCurrency, it also has an exchange rate field tblCurrency also has an exchange rate field where I can set the exchange rates for each currency I need a query to...

OK makes sense, to note however that I've an update query that multiplies the cost price by the exchange rate to then produce a USD price, this updates the info table. I presume I'll need to change this so it: 1. Looks at the date in the info table and date ranges in exchange rate table 2...

The historical data for exchange rates would be in the info table as you'll only be updating the records in the date range. That said I have decided to modify it, in that I'll have an exchange rate table, therefore each month you enter a date range and a exchange rate for each currency? Before...

No I tried to keep the exchange rate table simple, it was primarily just as a lookup tbl for the info tbl to get the currency from

Hello All, Sorry for another question!! I have three tables 1. Date range 2. Info 3. Exchange rates I need to create an update query that does the following: 1. Selects all records in the Info table based on the date range in the date range table - I have done this 2. Then updates all the...

Done, thanks

Only easy when you know how!! Have looked through the tutorial page but nothing I try seems to work (n)

Hello, This should be easy but I'm bang my head against a brickwall... I have a table which has amongst others the following fields: Budget Code - This is linked to another table which has the various codes in Cost Date With data something like 4300 Training 100.00 12/1/21 4210...