Search results

Hello Need help with an iif statement or maybe a Choose statement in a Query or what ever works I have the following data There are 12 pay periods Jan to Dec now some pay period may get a bonus (see below) Pays Jan--$1200,feb--$3000,mar --$2500,apr-$2900,may--$6700,june-$2300,july--$5000...

Hello Need help with my report/query. I have attached my database if someone doesn't mind looking at it. My report Payment Distribution is based on the query Payment Distribution and works good but when I try to get the liquidated damages into the report I get funny answers under the...

I have the following code gives me this error "you can't reference a property ormethod for the control unless the control has the focus Private Sub Payment_Quantity_Change() ' Get the first digit of the value in the combo box Dim firstNumber As String firstNumber = Left(Me.Parent.Combo4.Text...

Hello Need help with Control Source in a combobox in my subform. The main form has a combobox the user picks an Item No from the combobox then it updates the subform with the matching records. The user can now update or add records to the subform. One of the combo box in the subform has a...

I have the following table: acctable acc a No--123 acc b No--456 acc c no--678 I want to list 123,456,678 in a combo box. When I place my Combobox in my form it comes out in column 123,456,678. But I need come out in a row 123 456 678 Any help would be great Alfred67

Hello Not sure if this is the right spot for this but, I need help. In my report I must place Liquidated Damage amount in the 400 row only and that row uses a different calculation for the rest of the columns beacuse it must take in account the Liquidated Damage amount. I don' know how to...

Hello I have generated a report based on a query and user input. Is it possible to lock the report and save it under a different name once the user is happy with the report. I want to be able to reopen the saved report without having to run the query or the user input again. Alfred67

total hold back: [construction hold back amount]+[guarantee hold back amount]?? Construction hold back amount =10 Guarantee hold back amount =3 Should give me 13 but it gives me 103 Help?? Alfred67

Hello I don't understand why this doesn't work Desc: IIf([group100]="100",[sec 100 sanitary],IIf([group100]=200,[sec 200 waterworks],IIf([group100]="300",[sec 300 Drainage],IIf([group100]="400",[sec 400 roadworks Current])))) It only does the first one?? Maybe switch would be better...

Hello How do I get my report to add up all same item numbers ? I have the following in my Query Item,SubItem,Quantity 1,1,4 1,2,6 2,1,88 3,1,33 3,2,11 3,3,45 etc I'm looking for the following results item, Total Quantity 1,10 2,88 3,89 or does this Question belong in the query section...

Hello Is it possible to pull a value from a subform to put in your Query?? Example : In my subform Subitems one field is Total Tender Quantity =Sum([Tender Quantity]) and I need this number in my report/Query Thanks Alfred67

Hello I'm using the following to create gridlines in my report which works great if my data is in the Detail part of the report but my data is in the Item No Header section. What do I have to change to get the code to work?? Dim CtlDetail As Control Dim intLineMargin As Integer ' This is the...

Hello I would like to Thank everyone who are help me. You guys are great I'm trying to force a page break per group , everything I try gives me one item per page . I have a list of number items (example 100,101,102...201,202 etc) I need a different page for the 100's, 200's, 300's etc...

Hello Is there an easy way to add grid lines to my report ?? (like in excel) I'm running Access 2003 Thank you Alfred67

Hello I’m really stuck here. I'm fairly new at access In my table “items” are paid everyday. At the end of every month I have to produce a report showing which “items” were paid for that month (example February). My problem is I still have to show the “Items” that where paid in other...

Hello Need advice on how to tackle the following : This is the table structure that I use: Item Detail Table ============= Itemid Item No Item Description Unit Unit Price Sub Code information Table ===================== subcodeid Sub code no Sub code Description Tender Quantity Itemid...

Hello I can't get my if statement to work in the Query If <[Start Date] And >[End Date] then [Payment Quantity] = 0 Keep getting error How should I rewrite it?? Thanks Alfred67

Hello I’m fairly new at access. I’m writing a payment progress program for road construction. The problem I’m having is the following: As work progress items are paid once they are completed and at the end of every month Items are summarized and a payment are issued. The problem I’m...