Search results

Yes of course. I have a table of financial transactions in which the transactions are recorded in rows. More specifically I have a separate field for "month". Currently I am building a form in which I want to show the monthly variance of the general ledger accounts. In order to do so I wanted...

Hi thanks for your answer. It seems to work. Two questions to understand. You now only include "T1.ENTITY=C.ENTITY" to join the two tables but if their would be different cost centers or accounts used would you then also add "T1.COST_CENTER=C.COST_CENTER"? What is now exactly the impact in...

All, A very simple question but I can not wrap my head around it als having looked into some examples on different fora. I just need to deduct month 1 from month 2 (from the table fusion_entries) written by means of a sql code in Access (I know how to fix using normal queries) by joining...

I am definitely not a database expert but to my knowledge putting month data in columns/fields has the advantage that you use less memory in the table where you share the other fields of the specific values. Also driven by the fact that I am not sure how you would efficiently deduct two months...

Grateful for your input guys and hopefully the discussion is valuable for the forum.

With value field you mean the explanation field I want to edit? How do you add a unqiue index on the value field then?

Works indeed, for which many thanks. I only noticed that you assigned the primary key of the account per manager table to the account field. How does the primary key of this table interact with the primary key of the VZ trial balance table? (that's my ignorance with working with primary keys)

Thanks let me try adding the PK's tomorrow. Would the PK be required to locate the exact record or something? I suppose the spreadsheet format will not be a real issue when updating the cell? Many thanks Michiel

All, I have a very simple question. In the attachment I have a form populated by a query on a table. Would I be able to directly edit the 'explanation' field by populating the bounded text box on the form. Now it simply does not allow me to write in it but I don't know why. Thanks in...

Really appreciated! Thanks. It works fine. Two questions for my understanding. I should never have used a list box in this situation? I expect the listbox could do the same as a combobox here? And is the use of a query for getting the result in Act_Value the best way or should you recommend...

All, Hope somebody can help me with something I can't get my head around with. I have a very simple userform of which I want to populate list box "Act_value" with the result of a query which criteria are dependent on selections made in comboboxes. I added the Access file with only the form and...

Hi all, Can somebody help me out with the following. In a query I use the following dlookup field: UWN10: DLookUp("[waarde]";"forecast_Budget_Premium2";"[combi]=[Combi3] & 'UWN10' & [Veld]") In wich a new field is created looking up a value in this query by using a concatenated search...