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

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

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?

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