Recent content by jmhicsupt

I have a database that has the following: Manager Supervisor Secretary Joe Doe Susan Doe John Doe Where Manager, Supervisor and Secretary are three separate fields. I would like to change to so that I have a "Title" and "EEName" field: Manager Joe...

I have employee's name in one field. The field is displayed as doe, john. I now need to display the field as john.doe. How would I do this? Thanks in advance.

Thanks for the quick response. I was not totally clear. In my report, I only want to display the products apples and oranges. However, the customer may also have grapes and plums. So I want to get the total value of the customer in the query. Apples = $1.00 Oranges = $1.00 Grapes = $1.00...

I have two tables and I would like to calculate the total amount of sales from one of the table. In MainTable: Customer (maintable.customer) In SubTable: Customer (subtable.customer) Product (subtable.product) In my query, I am limiting the products to "oranges" and "apples". However I...

I have a query based off of a subform. The subform will have multiple entries for the client's name. Then they will also have the amount that we invoiced them. Is there a way to have a total column that would sum up all of the invoices? I need this field so that I can sort the records by the...

Is there a way to have the user in the subform add a record at the beginning of the subform? My subform has many lines and I would like the user to be able to have the most current date at the top and then when they press Ctrl+ they get a new line at the beginning of the subform. Thanks in...

I have a database that many managers access. I would like each manager to be able to click on their respective office locations to see their locations they are responsible for. Some managers have more than one location. So what I am trying to do is - if more than one checkbox is chosen, then...

I have a mainform and a subform. On each record in the mainform is the district name. Then on the subform are the employees and their associated travel. Now I need a way for the supervisor to see all records for their particular district and then approve the travel. What is the best way to...

I am trying to do a ODBC connection with an Access database. However when I do Get External Data, the only option I have is for the tables, not the queries. What do I need to do so that I can see the queries? I have already built the queries and all I want to do now is have an Excel file...

Duh on me. I figured it out based on the above. Thanks - this site is so helpful!

I am trying to do the same thing here -- "I have data validation for a drop down list with a condition with the named ranges to populate the dropdown". The response said to use INDIRECT formula. I don't understand how to do this. Can you give me the formula of how it would be written...

What would I group the query? Fieldnames: EECommentDate (date field that I would want the latest comment) EEComments (memo field that contains the comment) QryEEInfo is name of query Thanks in advance.

I have a report based off of a query. In the query is a field [EECommentDate]. In the report, I want to display the latest comment only on the report. How would I do this? Thanks in advance.

OK, success by using just your first formula. Now I have another question to complete my report. There were four sets of queries which I combined with subforms. Qrysalesrank Qrysalesunitssold Qrysalesstorerank ... Now I need to add up all of the rankings to get the top achiever. In other...

I tried your first code for the Dcount. That works wonderful except I would like to start at "1", not "0". Is there a way to start at 1?