Recent content by ecojohnson

Hi gmmastros Thanks for the tip. Here's a star.

Hi everyone. I am trying to create a table that has two columns, column1 and column2. I want a loop so that column1 starts with 1, and end with 2000 (counting up by 1). I want column2 to have a random number between 1 and 999. I have each of these working separately. For column1, I have...

Great - thanks. I wanted to try to get this figured out before the weekend. I'll give it a shot. Thanks again.

Thanks Skip. I was able to get close, but the macro returns an error: "Run-time error '9': subscript out of range". The code in question is: Selection.AutoFilter Field:=1, Criteria1:=">=" & Sheets("Sheet1").[A1], Operator:= _ xlAnd, Criteria2:="<=" & Sheets("Sheet1").[A2]

Hi everyone. I am trying to create an excel report where I specify a date range on one of the worksheets. Cell A1 might be something like: 4/1/08, and cell A2 might be something like: 4/30/08. The remaining worksheets are set up so they each have various information on them, and this...

Yup - thanks for the help. I appreciate it.

Thanks lbass It worked like a charm.

Hi drtree Yes, that's one thing I wondered as well. However, I have full admin rights on both machines. That's why it's so strange. I'm scratching my head so much, I'm not going to have much left. My only other idea is to uninstall and reinstall. I really don't want to, but if that's what...

Argh. Sorry. My version of crystal is 9.2.2.634.

Hello. I manage a permit tracking database and use crystal reports. I am creating a report where I want to count the number of permits where the date the permit was issued was in the current year - without including permits from the current month. So, for example, I would run the report today...

Hi everyone. I downloaded and installed a 120 day trial version of SQL Server. This included the entire suite (query analyzer, profiler, etc.) I was trying to run a trace using SQL Profiler, and then save this trace to a file, but ran into a problem. On the Trace Properties dialog, there...

Hi everyone. Is it possible to create a global header? This would be where I could create multiple reports that all have the same header (rather than recreating it every time). I know this question must have come up before, but I don't see anything specific to this. On one of my searches...

Yup - that was it. It was the ORDER BY that I was missing which did the trick. Thanks so much!

Hi dinger2121 Thanks for the tips. However, this does not work. Using the TOP function will return the first person, not the person with the highest number of reviews. It seems I somehow need to use the MAX function, and I cannot do this without creating a new table from a query (similar to...

Hello. I have a problem that seems absolutely trivial, but I cannot solve it. I have a MS-Access database table (called REVIEWS) that has the following columns: NAME NUMBER Andrews 12 Green 4 Jones 8 Smith 15 Green 10 Jones 9 My goal is to write a query that returns the person with...