Search results

I add a field as ... Month:[what goes here?] Thanks Mark for the help.

I made a work around: I created another table with all dates, plus a column that shows only the first of the month (e.g., 6/20/2015 in one field, has a 6/1/2015 in the other). I don't like this solution as I will have to maintain that table, but I can get the report out I need right now. Would...

Thanks. It's not a "number." It's text (October 2016), based on a query summarizing data by month.

I created a query that sums hours worked by month. When I sort it in the report, it sorts alphabetically instead of by date. How do I fix that? Thanks.:banghead:

And you're right this is outside of my skill level (never let that stop me, though). I'm a finance professional and I use ACCESS one of several tools. I'm not a developer.

I couldn't get my head around it but I ran across a posting where someone said they did it. I moved historical data into Access by first "unpivoting" it in Excel. That worked surprisingly smoothly. Thanks,

I'm designing a tool for staff to enter hours worked on a project by dates. I want the data to go into a flat file, and I'll do cross tabs for analysis. But the users are accustomed to doing this in a spreadsheet with Dates across the top, and projects down the rows. I'd like to design a form...

I hope she loves it.

I should add that while I took a VBA course, I barely remember it. I would like to see solutions for people that don't know VBA. This may be somewhat limited, but works for the way I use ACCESS.

I was first introduced to databases in 1987 with Paradox - a nice DOS based and powerful relational database. I started using ACCESS a few years later. I was working as an economic analyst and used it to analyze the housing market, labor forces, and other data. I later used it in my work in...