Recent content by beautifulminds-us

I have to admit, I don't know what it's called and haven't built one in years. I remember some of the VB but not all. Let me try to explain what it is... A form for that lists clients by their last name. You can click a button, the letter "S" for example, to list only those with that last name...

I have another... How do I group the dates on my query to show only a certain month and year?

Okay, I am a moron. I don't know what I was thinking when I made each table. I remember trying to make only one initially, but thought, "This won't work...," and made several instead. Then when you mentioned the above I began banging my forehead against the desk...stupid, stupid, stupid...

Wow!! Sorry, I left after waiting for some time. I am amazed at the replies and will do my best to answer them...:eek: Each expense (gas, phone, etc.) has its own table. Each table is connected to a subform. Certain prices that are known are fixed, i.e. postage, copies, commission. All that...

I am trying to build a db for my small company. I would like to set up a report that has the same functions as a bank statement so I can show my clients what they have made on a certain date and what they have spent, as well as the balance. I thought it'd be a simple SQL but was wrong. I went to...