Search results

I did but they're linked to another tbl rather than me entering the lookup value

Hello All, I have done some VBA to export a query into excel which was easy. Issue is that this is then to be imported into another DB. There are several combo boxes that take data from other tbls, instead of exporting the number it exports the actual text, this owuld be fine except when you...

Sorry not all access wizards....trying to do this alongside a day job

Each FE user just has the same FE but with differing options on the main form (I don't have seperate log ins etc, for them, just their FE version has a slightly different form to the others). I have the following setup: tblExpenses tblCodes tblExpenses has a lookup field that looks up a...

OK. So I've a combo box called Budget Code, this shows a list from tblBudget![Budget Code], what logic would I need to only show budget codes that start "0.*" (text value)?

Hi All, I have a combo box that looks up values in a tbl. Is there a way in the combo box control that I can change which values it shows for different FE users? But without having different queries to designate the criteria? I thought I could just use a query and control the combo box with...

Awesome, thank you

Good Morning!! I have a total qry which returns the following: Budget Code(Group By) SumOfBudget (Sum) 0.01 Management 50000 0.02 Bank Charges 6000 0.03 XXXXXXX 10000 1.01 XXXXXXXXX 20000 1.02 XXXXXXX 30000 2.01 XXXXXXXXX 40000 2.02...

This seems like the better option but I cannot seem to get it to work, this is my SQL: SELECT [2022 Monthly Totals].[Budget Month], CDbl([SumOfBudget]) AS Budget, CDbl(Nz([Sum Of Home Currency (USD)],0)) AS Actual FROM [2022 Monthly Totals] LEFT JOIN [tblExpenses Query1] ON [2022 Monthly...

Hi All, I've a chart based on a query, the query is all in order but the chart X axis is not, any ideas on how to make this correct? Cheers

Hi Arnelgp, Good idea but the date field in qry2 is a Group of dates from a total query that returns a grouped value of dates in a month...IE 1/1/21 45000 2/1/21 10000 2/2/21 5000 3/3/21 1000 Returns Jan 21 55000 Feb 21 5000 Mar 21 1000 Therefore the left join query does not work as...

Hi Arnelgp, Good idea, however the dates on the qry that calculates the monthly expenses are not a normal dates in that it only shows the month and year from a range of dates, here is my SQL that works out the monthly total expenses: SELECT DISTINCTROW Format$([tblExpenses].[Date],'mmm yyyy')...

Instead the IIf statement always puts a zero in for every month regardless is there is any actual spend or not, thats why the above shows two results for the months where there is an expense

I want it to only show one Date (each month of the year) and next to it show the budget total (which is already entered for the whole year), then in the next column I want the actual spent.....this is where it goes wrong, I tried to put an Iif statement in so that if no expenses were made that...

I have the following SQL: SELECT DISTINCT [2022 Monthly Totals].[Budget Month], [2022 Monthly Totals].SumOfBudget, IIf(DatePart("m",[Date By Month])=DatePart("m",[Budget Month]),[Sum Of Home Currency (USD)],0) AS Actual FROM [2022 Monthly Totals], [tblExpenses Query1]; But it still shows...

I could do this with an Iif statement but unfortunately the date in qry2 is from a totals table so it groups them by month.....any ideas

Thanks for that, yeah I'd thought of doing it like that in exporting it. Another issue......Haha! Today is full of them!! So I have 2 queries that look like this: qry1 Jan 22 $50000 Feb 22 $100000 etc... until Dec 22 This is my budget totals for each month. qry2 Jan 22 $45000 Feb 22...

Thanks for this, agreed a lot of extra work for something that will take me a few hours a year to complete. Thanks again for all your help

Hi thanks for this, I'd actually changed the rows/columns because of that. Noted about the lack of ID in the crosstab....explains why you can't update it. It will only be me updating the budget so maybe I'll live with the awkward way of doing it, it's only once a year after all! Sounds a like...

Only thought I've had is to do a normal form with this crosstab as a subform within it that then requeries on update on the main form......it not ideal though