Recent content by Craig Alan

Beetle, Thanks. When I crack open a cold one tonight, I'll raise the bottle to you and your awesomeness. You saved my day.

Hi. I'm learning and have just (maybe) shot myself in the foot. I spent hours today creating some reports. They're beautiful, work properly, etc. The problem is that I created them in a earlier saved version of my DB. I opened that earlier version to experiment with and forgot that fact...

Thanks CJ! You have saved me hours of frustration and I am grateful for your willingness to help.

Beginner. When I attempt to use Repot Design to create a report from a query, no queries appear in the Field List window on the right side of the screen. (I can create a report from the query using the wizard but I want to fully design my report.) How do I get the queries to appear in the...

Thank you, Plog. I appreciate your reply.

Beginner. One table database. Two simple queries from that table. When attempting to create one report (via Wizard) using both queries I get: "You have chosen fields from record sources which the Wizard can't connect. You may have chosen fields from a table and from a query based on that...

Many thanks to all. I used Plog's solution and it killed this problem off! A cold beer for each of you.

Novice, losing my hair. Simple DB, one table, tracking stock trades, one trade per row, date column along with many others. Each trade gets a date. Often I make more than one trade a day and I want to calculate profit/loss per day. So, I need to get a total of unique dates. "Count" gives me...

Hello. I'm new myself and learning. I love Toronto and saw "Sunset Boulevard" there years ago. My wife and I wanted to see "Phantom" but kids got the higher priority. Access has been tough to learn for me so far. Good luck.

I am new to Access as I now want something more robust and flexible than Excel. So far, my relationship with Access is love-hate. The learning curve is steep...and my head hurts...but I am making progress and love to learn. I often feel like I'm trying to ride a wild horse! I live in Ohio...