stateemk
Last Activity: Oct 19 '10, 04:24 PM
Joined: Aug 7 '09
Location:
-
I emailed you a condensed version of the database. Let me know what you think when you get a chance.... -
The only reason the code that's already in the report isn't working is because in Region 9 (9000 series), there are some 8000 series. The 8000 series represents the statewide codes so when someone in Region 9 chooses an 8000 code, the report is set up to display the numbers in ascending order so it wants to display the 8000 numbers before the 9000 numbers when it's in the 9000 series. It works fine for every other series, because all the other...Leave a comment:
-
I'll have to go with the first method. How would I do that? Thanks for helping out....Leave a comment:
-
I'll have to go with the first method. How would I do that? Thanks for helping out.Leave a comment:
-
This is a report that is going to be ran from year to year and the number of pages will be different every year....Leave a comment:
-
Here's the attachment with the Interpreterstes t table which feeds the form and the Previous Certification table which feeds the subform....Leave a comment:
-
Move a record from a form to a subform??
I have a form set up with current customer certification on it. The customers take tests and test into different certifications. I need to be able to have the current certification for the customer on the main form, but when a customer tests into a different certification, I need to be able to move some of the old certification data to a history subform and add the new certification data. I have attached an example of what I am needing to do... -
Thanks so much for all your help.Leave a comment:
-
There is no max.Leave a comment:
-
Consolidate data from multiple rows into 1 row??
I have attached an example of what I am wanting to do. Please let me know if you have any additional questions or need more information from me. Thanks.... -
Yes, I want the 9000 to appear in the blue before the 8xxx series.
Yes the IIF statement is the code that is in the blue header area.Leave a comment:
-
How to correctly display report details
I have attached two pdf files of a report that I'm trying to get right. The Regio1000 attachment is correct. The Region9000 attachment is not correct. There should be a 9000 Undesignated Region 9 in the blue section of the Region 9, but since the report is grouped by Region (listed in the tan bar above the blue) then by Code, it doesn't pull the 9000 charity code first so it won't display in the blue area. Following is the code for the blue area.... -
How do I find duplicates in an ADP?
I have an Access project and need to find duplicates in table. How do I create a query to find the duplicates? -
Thanks for the suggestions. I will try tomorrow to see what happens and let you know.Leave a comment:
-
Currently there are three columns in this table. The first column is the EmpID which is a text field with 9 characters. The second column is SAM2down which is 10 characters. The third column is dedamt which is a calculated field. Its format is a number field with a double field size and Auto decimal places. Below is some sample data from the table.
EMP_ID SAM2down dedamt
999999999 MSECCMSECC 3
888888888...Leave a comment:
-
stateemk started a topic How do I add leading zeros in an amount field and remove the decimal point?in AccessHow do I add leading zeros in an amount field and remove the decimal point?
I'm sure there's an obvious answer for this, but it's not coming to me. I have a make table query that figures a calculated amount for one column. I need to convert this table to a text file with no spaces or delimiters. The calculated field needs to be 8 characters with no dollar sign and no decimal point. How do I get the leading zeros in the file and the decimal point out? -
Sorry, I meant to include this in my previous post. When the "Property Type" is null, it will show zero in the CountOf Property Type column even though there are one or more records with a null property type.Leave a comment:
-
Here's the query that is not giving me the right count. When the "Property Type" is null, it will show zero in the Count column.
...Code:SELECT [Residential Sale].[County Link], [Residential Sale].[Sale Year], [Residential Sale].[Property Type], [Residential Sale].[Source Assessor], Count([Residential Sale].[Property Type]) AS [CountOfProperty Type] FROM [Residential Sale] GROUP BY [Residential Sale].[County Link],
Leave a comment:
-
My query is not giving me the right count with try to total columns
I am trying to run two queries. One query is doing a count to figure out how many total sales there were each year based on the assessor. That query is working fine. On the other query, I'm trying to get a count of the property type grouped together by year and assessor. The problem with this query is that somtimes the property type is blank and that's okay, but the count is not counting the blanks, so my numbers aren't matching up in the two... -
The user is going to try to keep track of how many characters she's entering when the error occurs. She said she does paste comments into the memo field from time to time, but that she has never gotten the error when pasting, it's always been when she's actually typing. The following message comes up in the log when she gets the error, but I can't find anything specific on it.
If I were to recreate the database, would that...Leave a comment:
No activity results to display
Leave a comment: