Search results

Can I use dlookup in the row source??

"how big is the database" It's 8mb but if I zip it's 1Mb If I change Row source type to Field List it will give me a list of the field names maybe I can work with that Alfred67

Sorry if a confused you. I have attached screen shots that should clear it up. Screen shot 1 --is my Account table Screen Shot 2 --is table in view mode Screen Shot 3--shows my combo box See how the acct numbers go horizontal I need them to go vertical and allow me to pick anyone. Hope...

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

I got it to work :-)

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...

I'm using access 2003. I'm not sure how to do that Alfred67

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

Thank you for the fast reply and it worked like a charm. You saved alot of grey hair 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

Thanks for the help. Got it work now 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...

Thanks for the link. This helps me out alot Alfred67

Sorry I didn't realize that. Thanks for the heads Up Alfred67

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

Yes it was ?? I used your IIf statement, Date was just mod it to include day,month, year Alfred67

Yes, Date is a field. I was worried about the year too. So I have a pop up start date and pop up end date. Which gives me day,month and year. Seems to work good Alfred67

Hello Thanks for the help Guys This is how I got it to work Quantity This Period: IIf([date]>=Forms![start date]!cbotype And [date]<=Forms![end date]!cbotype,[Payment Quantity],0) Thanks Alfred67

No didn't work :-( Alfred67