I created a form to display record details based on a table and then also based on the results of a query I use to specify which records I want to see. The...

I am trying to replace the first six numbers of a Social Security NUmber with Stars and display only the last four digits in Microsoft Access. I would like...

I pulled data from 4 different tables. This data now needs to be sorted into months using the Receipt Date if it has one. If there is no Receipt Date, then...

The following is an if-function i am trying to get working but it doesnt accept it and shows me if the cell ! equals to 5 it gives in the cell for '�ndice...

I have a form where you can enter new product names and it is stored in table1. I then have a query that combines the productname from table1, product...

Okay, so i have been learning very slowly the dos and dont's of access. But when I try to make a query (perameter or simple) it is not coming up with the...

Good morning: I am working in Access 2000, and I am trying to set up a cross tab query that will calculate the monthly total of our product in stock. The...

Is there a way to have a subtotal at the end of a group like the SUBTOTAL function in Excel? Thanks

I have a table that gets a new YTD entry once a month. Sample data: Officer# OfficerName Month YTD 100 Jane Doe 7/31/06 ...

I have a query which compares two text fields for an exact match (I thought). I find that it finds differences in the text strings if there is a leading...

why do I get just the sum with Avg(+...) and how do I avoid trunacation of my formulas?

Hi, I want to create a query that employs a dropdown to allow the user to select information from a specific field in a specific table. The purpose is to...

Hello All Wondering if anyone has some insight into my latest dilemma. I'm building a database to handle stock quantities and location. So I have a table,...

I have a between date type parameter query. How would I add error handling to a parameter. Example: If the user puts in the wrong date. I want it to return a...

Here is the trick. I am using 3 queries for my report. Two of the queires (sub) are based off the main query that holds the main parameter. As you have...

Hi Is there a way or retrieving the record ID of a record just added within the same SQL statement or similar method I am new to Access and in SQL Server...

Hello anyone I have this query that returns the values i want. When i use another query to sum the query it returns the total times 3. i just want to return...

I have a field in a table named Author where som authors ends with a period '.' and som do not. Ex. L. Stone. or F. Olsen I want to put a period at the end of...

When I run a query I want to create a blank record with a message "no previous record" without upsetting the primary key field and the underlying database- ie...

I have a tour bus reservation system and have an interesting challenge. I need to build a crosstab query to show how many buses of each type have been...