Recent content by itsjamaal

=DLookup("Sum(trans_amount)", "transactions", "trans_mode = '" & [trans_mode] & "'") I have added a text box next to trans_mode, when I select that, it shows the current balance of that trans_mode. Now I will check on reporting, Thanks in advance for all the guidance given.

Private Sub trans_type_AfterUpdate() Me.trans_category.RowSource = "SELECT category_name, category_id FROM category WHERE trans_type = " & Me.trans_type & " ORDER BY category_name;" Me.trans_category.Requery End Sub Private Sub trans_category_AfterUpdate()...

Now I have created some tables. I need to create a form for "Transactions" When I select the 'trans_type', then 'trans_category' should be filtered based on that selected value 'trans_subcategory' should be filtered. Guide me to achieve this. I will add my questions once I am done with the above...

I would like to convert my Excel into an Access database. I am attaching the file here. Please guide me to have a well-arranged Access database.

Hi, I am Jamal. Just want to learn Access. Hope people here will be helpful.