Search results for query: *

Yes, I have "group by" for the [salesman] field but I still have a problem. I have a [Number of Sales] field with a DCount formula that correctly calculates the total number of sales when set to "group by" (all salesman show the total number of sales for the column, Adams =...

Thanks for your response but I'm having trouble creating the totals query. I am able to get a total for an entire column but can't get it to separate the activity per salesman. For example, using my previous post, totaling the Date Closed column gives a value of 6, I need to know that Adams had...

Thanks for your response but I'm having trouble creating the totals query. I am able to get a total for an entire column but can't get it to separate the activity per salesman. For example, using my previous post, totaling the Date Closed column gives a value of 6, I need to know that Adams had...

Existing Table: Cross Cross Date # of Sale Sale Closed Spreads (1) (2) Adams 1/1/03 3 RREM DDA Adams 1/5/03 2 DDA Adams 1/6/03 2 Jones 1/1/03 1 RREM Jones 1/2/03 1 RREM DDA Jones 1/6/03 1...

I have a drop down menu with the following items: Drop down menu #1: Residential Real Estate Treasury Management Investments I would like Drop down menu #2 options to be limited. For example, drop #1 choice is Treasury Management, then drop #2 options are limited to Treasury...

Is it possible, when opening access 97 for the program to ask the user his name (or other identifier) and then auto populate fields with the user's info (for example division, location, name, address) [maybe using autoexec] while allowing the user to only look at data he has input? I don't need...

Works great. I was able to combine columns using IIF but your method is much easier. Thanks for your help.

My query calculates due dates and must use three fields due to the large size of the formulas. Consolidating the formulas to one or two fields results in a "too complex" error message. I would like to combine the results of the three fields into a single field. The formula output for...

Your suggestion worked. How can I use a wildcard in a formula to account for spelling differences? For example: Audit, Audited, or a misspelled variation. I tried to use "Aud*" but this didn't work. Thanks for your help!

I agree, DateAdd()is easy to use. I am able to add a specific number of months etc. to every date in a column containing dates. What I can't figure out is how to add different numbers of days to the date in the Last Date Received column based on the type of financial statement listed in the...

The formula in the Date Next Due column causes syntax errors and does not work in Access 97. It works just fine in Excel 97. Please help. Required Last Date Document Frequency Received Audit Annually 12/31/01 Compilation...

That works. Thanks for your help.

Are the logical tests in excel 97 limited to numeric fields only? The following IF statements produce a FALSE result but field A4 does equal Audit and A5 does equal Compiled. 1 A B C D 2 Date Last Date Next 3 Document Frequency Received Due 4...

I have two tables. One with Company Name, Number of Employees and Address, the other with Company Name, Sales Size, Address and Phone Number. The tables are from different sources. Can I combine the records of these files based on a 70%-90% match of characters in the company name field? The...

This is very annoying. I have created numerous queries of an extremely large database but Access 2002 will not allow these queries to be exported to Excel or any other program. It says the database or object is read only; however, I am able to delete the queries which makes no sense if it is...

I have a field containing alpha and numeric characters (street number and street name of a physical address). I have copied the field and now want to delete all alpha charaters in field one and all numeric in filed two so street number and street name are in separate fields (columns).

I am no longer able to export queries to Excell. Each time I try I get a message saying the query is read only. The help link associated with the message is no help at all. I am using my home computer and I am the only user. I was halfway finished with a project when my queries magically became...

Thank you for your help Maquis. I don't have SQL server but I was able to get around the unrecognized database error message by changing the extension from *.dat to *.txt and importing it as a table into a newly created but empty Access database. The file is too large for Access 97. I will...

How do I import or convert a 500 megabyte file with extension *.dat to Microsoft Access 97. Access says the file is an unrecognized database format. Excel, wordpad and notepad are able to read the file but it is much too large to fully open within these programs.