ckpoll2
Last Activity: Nov 3 '09, 03:57 PM
Joined: Sep 1 '06
Location:
-
You guys are great. Thanks again!! -
You are amazing!! Thanks so much for your help!!Leave a comment:
-
Update query to certain number format
I'm trying to figure out how to get an update query to work. I need to get dollar amounts into standard lengths and formats for export into our main system. The dollar amounts need to be 17 digits with zero's to the left and no decimal. For example:
$7.26 becomes 000000000000007 26
$24,974.57 becomes 000000000024974 57
and so on.
Can anyone help with what formula to put into the Update To: section... -
Make table query with default values
I've created a make table query that runs off of a crosstab query. Some of the fields within the crosstab are null, which I'm wanting to have show a 0 if they are null. I tried an update query on the table, but there are 10 different columns that could have nulls and I don't want to write 10 different update querys. Is there any way to set the defaults on the make table query? If not, is there any way to have 1 update query that can search each... -
Thanks, Fish. Actually, I didn't design this database. Unfortunately, someone else put it together and I'm just stuck with trying to make sense of it all. Do you know if my need is possible and, if so, how I can go about it?
ChuckLeave a comment:
-
Convert check boxes in a table to text boxes on a report
Ok, so I'm wondering if what I need to do is even possible because I haven't been able to figure out how to do it and I haven't seen any similar posts on here.
In a table, I have a series of fields with course names as the title (SAA-OC, SAA-TA, etc.) There are also fields with employees names and other information. Each record is a unique employee and, under the course name fields, there are a series of check boxes that show which... -
That didn't seem to take care of it. I have in the text box:
=IIf([Item Type]="Blitzes",S um([DDMS Items]),0)
Where the formula Sum([DDMS Items]) is what is in the control box and still no luck. Any other ideas? I feel like I'm really close, but just missing one crucial part of it.
Thanks for continuing to help.Leave a comment:
-
Thanks for looking into my problem.
I removed the double quotes, but that didn't seem to do it. I'm not sure what you mean by repeating the calc (control source). Can you type out what the formula should look like for me? I'm not very good at working with access. The [Sum of DDMS Items] is the name of the text box that is holding the calculation of the sum of all the individual listings of the items.
Does that h...Leave a comment:
-
Problems with summary reporting
Hello.
I have set up a report where the sum of counts of different item types are displayed in alphabetical order. Since I need to add certain ones together, but not get a complete grand total, I am trying to put text boxes together in the report footer with IIF statements, which I will then add certain boxes together to get the totals. What I have so far is...
=IIf([Item Type]="Blitzes",[Sum Of DDMS Items],"0")... -
Thanks for the reply.
Basically, what I need to do is have a list of selections pop up rather than a text box to enter data.
I've built a query (named Recon by Agency) that will return data for one particular agency that the user specifies. The problem is that they may spell it wrong or forget the name of the agency. Therefore, I'd like to have them select the agency (stored in table Agency Names) from a list that...Leave a comment:
-
Query Display List for Criteria
I'm trying to make it so that instead of having to type criteria in a query using [Enter Component Name], the user is asked to select a component from a list that pops up when they run the query. Is there VB code that can do this? I need to pull the list from tblAgency Names for use in qryComponents. I would appreciate any help you all can provide.
Thanks in advance for your help! -
any one have any ideas about this? I've been racking my brain trying to figure it out.Leave a comment:
-
Create list to choose elements
Hello,
I've created a query where the user is prompted to enter a component name using
[Enter Component Name]
I'm finding that they don't enter it exactly as it should be, so it doesn't return what they need. I'd like to have a box pop up that lists the available components and asks the user to double click on one of them. This way, they don't need to type anything in and risk not entering it properly.... -
Awesome, that worked perfectly. Thanks so much for the help.Leave a comment:
-
Validation rule for decimals
Hello,
I'm trying to set a validation rule for a field in a table that will only allow the user to enter whole hours or quarter hour increments, like 1 or 2.25. I'm using the following statement in the validation rule field:
Like "*.0" Or Like "*.25" Or Like "*.5" Or Like "*.75"
but it isn't working. When I enter 1.0, I would think that it should work, but it denies... -
Does anyone have any thoughts? I'm really stuck with this one. I would appreciate any help that you could provide.Leave a comment:
-
I've found that the problem isn't with the query itself because when I run it, it works just fine. It seems to be something with the actual report. Does this help any?Leave a comment:
-
That didn't take care of the problem. Any other ideas? Would it help at all if I posted a copy of the database?Leave a comment:
-
I was just now playing with it and found that it seems to have a problem with dates in 2007, but not with 2006. If I enter 5/31/06 as the end date, it's fine. But if I enter 5/31/07, it gives me the error message. Does this help at all?Leave a comment:
-
Here's the SQL for the query that the report is driven by:
SELECT [Personal Property Hours].[Transaction Number ID], [Personal Property Hours].Date, [Personal Property Hours].Name, [Personal Property Hours].Site, [Personal Property Hours].Type, [Personal Property Hours].[Tech Input Items], [Personal Property Hours].Items, [Personal Property Hours].Hours, [Personal Property Hours].Notes
FROM [Personal Property Hours]
WHERE...Leave a comment:
No activity results to display
Leave a comment: