Search results

Hi, somewhat new to the design of databases. Here is what I want to do... I have a table with 3 fields called tbl_WE: Credit#, CreditName, & CreditReq. Ex: Credit#: WEc1 CreditName: H2O Landscape CreditReq: Reduce water reuse Credit#: WEc2 CreditName: H2O No Potable Irrigation CreditReq...

I have read the forum and maybe an invisible field in the detail that totals the column then pulled that value into a new text field in the footer would work. Here's what I want to do... I have 6 records with balances due. My report currently prints only those with >0 balances. I want to total...

I have a report that provides extensive detail. I want to limit this report to show only those customers with Balances Due. Balance Due = 0, do not show on report. Do I have to create another query based on this? Or can I somehow modify the current query which has a calculation in it to show...

Hi RichO, thank you for your help. I have attached my db. The report returns all necessary info I want. Now on the report, I need to Group by each Company and have each Company, with their data put on a seperate page. Is there a code to write for OnOpen or OnActivate? Step by step this project...

Works perfect. Thanks so much!

I'll try and explain further. In a table, the Gross is entered. If a H/A is determined to exist, that info will populate a field also. For the Net field, I want that to reflect the Gross if there is no value for H/A or if there is a value for H/A, to multiply the Gross * H/A and that equals Net...

Hi, Trying to get this query figured out right. I have a Gross, H/A, and Net fields. If there is no value in H/A then Net = Gross. This is what I've figured out so far. In the Net criteria field in my query... IIf([H/A]=0,[Net]=[Gross],[Gross]*[H/A])

I have created a form with 3 cascading combo boxes. Whenever I open the form, it opens to Record 1 and all fields are blank. Doesn't appear to be saving the info. Please advise as to how to save the input info in the form. When I insert the field into the ControlSource, I am unable to enter data...

Hi RichO, I'll try and describe in more detail what I'm trying to accomplish. In the form, there will be entry of info such as date played, distributor, company, theatre and gross. When I try and create the form with cascading combo boxes, every time I reenter the form, I'm taken to Record 1 and...

When I try and "bind" to controlsource, it doesn't allow me to enter info in the field on the form. I have attached my db, would you mind taking a look and seeing if I'm doing this right. I need to be able to input some info in the form and then at a later date, go back and input payment info...

Newbie needs guidance Attached is my db that I have created. Tried to do cascading boxes with Company and Theatre. Now the Form creation is stalling me out. I can input fields from my tables and from my query but every time, it comes out different and incorrect. I need to have a form to input...

I created a form with 3 combo boxes. The first is for Distributors and in Design mode, it shows Unbound. The second and third are cascading, the first is Company and the second is Theatre. In the Theatre, in Design mode, it shows Unbound also. When I populate these forms and scroll back to the...

Excellent! Thank you for your guidance. It works!

When I run a report, do all my queries run also? I need to create a report sorted by each Company and all corresponding info. Each company needs to go on it's own page. How do I make this clear in my report?

Thank you, I created a query for Balance Due and for criteria, I used >0. This seems to pull up the ones with balances due. Thanks again.

thank you, I did just that. Merged all data into one table. Created combo boxes and bound boxes so all data can be entered easily. Now...my query...I need to calculate the Net, Film Rental, and Balance Due. I have done that. When I try to create a report, I am not able to use a table and a query...

I need to create a report that prints out only those records that have a field marked. How do I do this? Do I have to create a query?

Thank you so much. Now....let's say I have 10 companies so there are 10 tables. I want to use one form and have that info populate the table. I have created a combo box to include different info that spans all companies. When I am done with entry and calculations are completed. How do I create...

Just so I am clear....when I enter information into the Form, it will populate the table? So if I have to go back at some point and change a value, I can do that from the datasheet view? and then rerun the report which will rerun the query which will rerun the calculations? I have to create a...

I have created a table with gross, net, terms, total due, etc. Then I created a query to do calculations which seems to work ok. Although if there is no value, the whole calculation returns a 0. I have put a default 1 value in the record to bring up a value. How do I populate the table with the...