Search results for query: *

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...

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...

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...

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...