Search results for query: *

You guys freakin amaze me!!! Thanks, that did the trick. I created the formula in the main report and it worked like a charm. Thanks lboss and groggle.

Should I create this formula in the main report?

Thanks, I figured this was the problem. I tried to change the field property in the excel file. Both are strings but the excel file is a standard 255 characters and I can't figure out how to change it. (the field in the psoft query is a 10 character string). How can I create a formula to make...

Worked like a charm!! Thanks.

I linked two tables using the same field from each, but the tables are from two different database sources. One table is from a Peoplesoft Query the other from Excel. The data source for the main report is Peoplesoft while the subreport's data source is from Excel. I'm able to browse field...

I want to insert a field in my report that prompts the user to insert text. Specifically, the report is a contract template. There are constant field elements coming from the related query. The only field that is not available in the query (and is a dynamic value) is the project name. I want...

Thanks for your help. I tried your first suggestion, but couldn't make it work. I ended up using Trim Right which worked for me. Right({NS_INVOICE_ID}, 13) Then I used If, then, else argument If{@Adjustment}= "012007_022007" Then "Adj" Else If {@Adjustment}="012007_032007" Then "Adj" Else...

can you elaborate? I'm not familiar with Instr and Mid functions to parse

Hi all, I am trying to use a wildcard in an If, then statement. It's not working because the field property is string and perhaps the use of quotation marks is looking for a literal value. The numbering convention for the invoices are: vendorID_Month/year services rendered_Month/year paid so...

Hi, I want to insert a chart in the header of my report that will show the top 10 users. I used the Select Expert to limit the results to the top ten but the chart shows ALL 50 users. How can I limit what data is used in the chart? Thanks,

I've seen some postings on here for creating procedures and modules to calculate the median. In my case I want to see the median of all rates in my table. I am using a fiedl that is data derived from an Expression using an IIf statement. This expression "looks" at other Rate fields...

I actually have three questions....here goes. First, I have a database in a multiuser environment. It's a small environment, so all of the users have full access. I created another database (also for multiusers), for the purpose of searching data only. The users have the ability to search...

Thanks Rod, I tried both of your suggestions. The first, I'm afraid might be a little over my head, so alas, it did not work. Please specify what I should refer to for SourceObj and FileObj and I will try it again. Then, I tried your second suggestion and created a macro for the mailmerge...

I have a table that contains contract information. I created a form to enter data. Each time we create a new record in the form, we open the table and merge it with a document in word97 to create a contract. We do this from either the table itself or from MSWord97 and each time ALL RECORDS...

Please bear with me as I am still a novice. I've created several modules in my database that when expressed in a query would "group" the data accordingly. It usually works like a charm. However, I get a "data type mismatch in criteria expression" error message for the...

YES....YES...YES!!! That's exactly right and the logic is so clear in the statement. Thank you!

Thanks so much for your quick response to my query woe...but, the results were the same. Actually, I had to change it to IIF([Rate]=null,"",[RenewalRate]) to give me at least part of the result. Maybe my explanation was too muddled. Please see an example of what the query or report...

In Access97, I have a table containing two fields "Rate" and RenewalRate". I created a query and would like it to return the most recent value of the two. Using "Rate" as the primary field, If "RenewalRate" has no value then return the value of...