Hi,
I am using an AutoExec macro to open a particular form when the database is opened. When the form is opened this way the form always prints out blank.
If I open the form from the database window, however, it prints out without any trouble.
Any ideas why this might be happening?
The SalesAgentID field can contain multiple id's. However, I just need the first one as this is the agent who initially submitted the application. The problem is that I need to display the agent name which is held in the Users table. To do this I need to join the SalesAgent ID field to AgentID...
Hi,
I have 2 tables:
1. Application
2. Users
I need to do a count of applications per user. In the Application table I have a field 'SalesAgentID'. I need to link this to the field 'AgentID' in the Users table in order to display agent name which is held in the Users table. The problem is...
I am trying to import an excel file into the database, creating a new table in the process. There are approx 25,000 records in the spreadsheet. However the data gets 'scrambled' in the table with values from different records being inserted into different columns.
Could this have to do with the...
Is there any easy way of desiging a report so that the data will be displayed in tables, including the gridlines. I know that I could export the data to Excel, however I need to export it to Word instead so that headers and footers will be included?
Thanks in advance
I have a very simple select query which counts and displays the occurrences of various result codes in a customer table. The data is output as follows:
Result Code Count of Result Code
LAO 10
LOT 8
The customer table is linked to a result code table. There...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.