Search results

Thank you so much for helping me :) I think I confused you in my explanantion of what I'm trying to achieve. I need the report to count the number of accurances for the reason for shredding. For example out of the five accounts listed in the report how many had "Account Closed" and "Hold for...

Thanks for the tip boblarson but I'm a newbie to MS Access and I'm not following your solution. I have attached a small scale of the db in hopes you can show me where to place your suggestion. The report should count only once the account and give the number of "Accounts Closed" and "Hold for...

I have a form called "HMLogMain" with the following fields [Account], [AccountName], [DateShred] and [ReasonToShred] that reside in the detail section. I also have a subform called "SubMenuShred" which captures the listing of the documents to be shredded with the following fields [DescOfDoc]...

I have a MS Access database which I ONLY allow the users to interact within the menu driven macros I have incorporated and buttons etc in the form. On a weekly basis they need to export a specific query into Excel. Can someone help me on how I can incorporate in my menu the EXPORT feature to...

I'm a newbie to MS Access and I need some guidance. I replaced one of the fields in my form design with the following expression =IIf([AMOUNT]>=10000.01,"YES","NO") so that once a user inputs in the field [AMOUNT] it will automaticly put a YES or NO depending on the amount entered. My problem...

Thanks HighTechCoach.. It's exactly what I was looking for. :)

Can someone show me how I can hide the main console that opens in MS Access and just open only the specific form the user will be working on. I saw this done once but I have not found a way to achieve it on my database. Thank you..

Yes, there lookup fields... Any suggestions, Thanks!

I have a field named [Account No] and in the properties of this field under the tab "data" I have the following a query built: SELECT [CIF Accounts].[Account No], [CIF Accounts].[Short Name], [CIF Accounts].[Relationship Name] FROM [CIF Accounts]; so when an account number is entered it will...

Can someone please help me construct the expression I have below. I'm getting an expression error. The expression should add a "1" to the count if it finds a "YES" in the field [form104Count] and a "0" if not. 104COUNT: Sum(([form104Count]="YES"),1,0) Thank you!

Thanks! MSAccessRookie... The formula adjustment you made worked out well.

I have the following expression in a Query and for some reason its giving me correct results for the part of the expression of [AMOUNT] but it is not calculating [TRANSTYPE] ="Cash-In" the end result shows Cash-In and also Cash-Out.. When It should only give me Cash-In transactions. Is the...

I have the following expression in a Query and for some reason its giving me correct results for the part of the expression of [AMOUNT] but it is not calculating [TRANSTYPE] ="Cash-In" the end result shows Cash-In and also Cash-Out.. When It should only give me Cash-In transactions. Is the...

Thank you everyone for your help eventhough the codes suggested was not the output I was looking for. For future members who have a similiar question below is the correct code: =Sum(IIf([FORM104]="YES",1,0))

Hi Khawar! Currently I have it as a text field for I imported the data, but evnetually it will be a yes/no field.. I tried the code you send me for the text field and im getting a invalid syntax error.. Looks like the single quotes you have near the & is causing it but no dice cant get it to...

I have a report that in one column I have a mix of YES's and NO's and I'm trying to add only the yes's and get a total. From research DCount is my best choice I believe to make this work. The report is pulling its data from query "Weekly Report Filter" and the field that is storing the YES's...

Can someone give me a hand with the function Dcount for a report the I need to total the number of "YES" for a field called [FORM104]. The QUERY name that its feeding the data from is called -> Weekly Report Filter and the query is using Table: Clients.

Can someone give me a hand on the below code, Im missing something but im not getting it. Im getting a invalid syntax "You may have entered an operand without an operator". form104Count: IIf([FORM104]='YES',Count[FORM104])

Thanks, dkinley... I was able to figure out what I was doing wrong by examining your sample database. Thanks A MILL!!

I'm trying to make two fields, [RELATEDTO] & [RELNAME] populate automaticly at the same time when field name [ACCOUNT] is entered by a user. In the form "Transaction Log" in the field [ACCOUNT] I have created a event procedure in After Update (see below code). Which populates automaticly...