Recent content by belovedcej

thank you so much! perfect. and it fixed ALL my errors in the larger query.

Thanks for the explanation and tips. It turns out I just missed the apostrophe when I copied from SQLPlus, so that part was ok. But I changed everything else. But now I'm getting a different error on line 3: ORA-00923: FROM keyword not found where expected I've run stuff like this on...

I'm having difficulty with the below query (actually just a portion of a much large one - thus the structure.) I am told "invalid identifier" at line 2, allV.AllVoters. However, if I swap the fields, I get the error at line 2 again, this time on allV.AllDate. Any ideas what is wrong? SELECT...

good research Melagon. I'm going to make a note of that, because it looks useful and I didn't know it existed till you brought it up.

true enough IIF would work. I just don't like all those nasty nested expressions! Makes me dizzy. LOL I wonder, too - would there be any place that these values would be used? Because if so, a table with the categories and values might be better whether SQL or Access, because who would want...

Well, you can do pie charts in access. Check out the wizard under reports, "New/Chart". However, I personally don't like them. They don't like as nice and tend to be hard to use when compared to Excel. For my users, I provide data that they can export into Excel and then make much nicer...

Correct, Access does not support a case statement. The cleanest "Access" way of doing this would be to have a table containing the possible categories and their values, and then do a sum of the values, grouping by employeeID.

I may be wrong about this - but I think I remember the NZ function being a "if the field is null, provide value1, otherwise, provide value2." If my memory is correct, SQL DOES accomplish the same purpose - it just needs to be rewritten as the following: Case When myfield is null then value1...

What I do is provide a table that contains a field of hyperlinks. Then the user can copy and paste the Windows address of the file or folder into the field in the database, and it's linked. Prevents you from having to store the file itself and bloating your table, and accomplishes the same thing.

Have them give you your own database that you have db ownership have. Then have them give you whatever level of permissions is appropriate for those few additional tables. They should be comfortable doing this, because in SQL security settings are pretty straightforward. They can give even...

For that number of people, moving to SQL is a better option. The problem is that with locking/unlocking records and other database issues, Access can end up corrupting the data if things aren't done just right. SQLServer handles all that much better and you won't have a data corruption...

open your database and go to tools/options. Choose the tab for forms/reports. At the buttom there is an option for "use windows themed controls". Check that, and your buttons should be rounded.

On the other hand, if you want to execute the query and then do something with the data using a recordset object in vba, you have the following options: TYPE 1 Dim rst As New ADODB.Recordset Dim cmd As New AdoDB.Command Dim parameter1 as string Dim parameter2 as string parameter 1 =...

There are a couple of ways of doing it. Perhaps the easiest is if you are opening a form or report based off of this query, open the properties dialog of the form or report, and under the data tab, put the following in the input parameter row. @myParameter = [Forms]![frm_1]![txtBox]

thanks for the clarification, genoman. I thought i remembered something about the report events! :)