I've created a Password in a Query... but I want a mask to be shown when the user is inputting that password - for example, "*********".

I am trying to create a crosstab or pivot table. I have one table involved that is used to track dates that employees call in sick. The fields I'm needing...

Hello, A record can belong to one of three groups and each record has a value attached to it. How can I calculate the total for each group as a percentage...

Hi There, I sometimes get the following error when I execute a SQL 2005 stored procedure using ADO VBA in Access 2003. -2147217871 MS ODBC SQL Server Driver

Greetings, I have a database table that has a row called "Company", which may return different variations on a company name, depending on how it was entered....

I have an append query that has alot of calculations in it and it takes several hours to run. I have tried copying and pasting the data but because of the...

Say I have Table A in MS Access 2000 with the following fields: id; school (humanities, science, medicine) and anxiety(mild, moderate, severe). I want to end...

I have created some queries that the user can use to search by adding certain criteria. However after a few uses the users find that they are asked for the...

I would like to be able to create progressive totals in a query for display on a chart. The total required only has entries every few months while remaining...

I am using a "Menu button" that opens macro that only allows me to import from a certain drive. Macro:Transfer type-"Import Delimited", Specification...

I have a table that list a count of peoples visits along with the State City and 5 digit Zip Code. I would like to query this data so I can get a total(Sum)...

This is the result I get with the following query: RefNumber InvoiceLineAmount InvoiceLineQuantity 65914 7.72 ...

I have a SubForm that is based on this Query/Table structure tbl_points Point_ID Primary Key the above field is linked on a 1-to-many basis to the fields...

I have a form that has 5 text boxes. 1) is the start date 2) is the ending date 3) is an expression:=Month() 4) is an expression:=Year() 5) is an expression:...

I have query results that I want to export to a CSV file but I need to have only 3 out of the 10 text fields enclosed in quotes "". Is there a way to do...

Hi: Can you please tell me how can I modify this query to identify these 'pairs': 1234A and 1234B; the below query is working when I have 1234A and 1234AX;...

The setup I'm dealing with is as follows: - The rows in both queries contain a field called 'system number' which is the field being compared. - In the first...

Hi All, I have a make table Query that pulls records which include invoice numbers (table name is PromoTableAgentIncentive). I have a query...

I have some tables that are named according to the date they are created e.g. 20080101TABLE, 20080215TABLE… and so on. The field names on these tables are...

I think I have a simple question. I want to create a query to list tasks with target completion dates scheduled before the end of the current month. I have...