Search results

Thank you, that worked.

I'm trying to use a DMax in a Continuous Subform to autopopulate the Date by the last entered Date in the Table. It works for the first entry but if I change the Date to a different day the next line populates as 12/30/1899. I have this code in my Default Value. Any help is appreciated...

I have the Federal Taxes fixed. I removed the 2nd job tax option from the table. Once I did that, it worked. The board members will never make enough money to pay State and Federal taxes. The only people that will are the Road Patrolman this would be their primary job. If they find they need...

I have fixed all those and need to load some data to test reports.

The Demo tables were all named that in the DOS program. Why? I have no idea. I don't care for it but it's really not important enough to change it.

Also, You are correct about the PK. I will update the tables.

I will correct the tables to be qryFedTax1 and qryFedTax2 as you recommended.

Yes, this was updated while I was answering. MyUCA is the code that is on the CT report filed with the State. 17 is the ID in the tblDemoUCA table. The Fed Tax Table matches the UCA code and Marital Status. This DB was originally designed in a DOS program and the references where the MyUCA...

The results for this should be Married, no 2nd job (which is null0 and Adjusted Income should be 17100 and 49500. Returned results should be 17100. I had this problem with State Taxes, which works. Federal taxes will not.

I have a query that is supposed to find Marital Status in a table then between lower and upper limits and return lower limit, else 0. It is returning all the records. The query is QryFedTax1, pulling data from QryFedTax. I know there as some fields that can be removed form QryFedTax but I don't...

With a little help from my friend the form is now fixed. A search combo box was added to the header for the Client. The Client Full Name box was recreated as a list box. The Orderby on the main form was removed and Editing on the main form was changed to No. Editing on the SubForm was changed to...

Do you think the ReceiptDescription should be from tblTransType or from the tblDemoUCAs?

This is what I was thinking. It is for Towns in the State of Wisconsin. The business in municipal business so most of the Revenue is taxes. I will work on it tomorrow.

Am I correct in thinking I need a table for a (example) receipt number and the receipt number or transaction number that then relates to the tblDemoTrans with multiple transactions with that receipt number?

It just has revenue related to a client by date with receipt number. The revenues are based off taxes received by date or receipt number. There may be other revenues by ex. driveway permit or cemetery payments but those revenues would never be from the same client. The service would described by...

So what i need it a table that contains ClientID and receipt number and then the data for that receipt is in the tblDemoTrans using the receipt ID for details? The way you have it, it contains all the data for the Client, I can't enter data. Is that correct?

Are you saying the I need a separate Revenue table from the tblDemoTrans? My tblDemoTrans does reference the primary key but it is doing a data look up.

No, the client could have more than one revenue receipt. What do you mean my tables are not designed to allow one client to have more than one revenue receipt?

Is there a way to make the field unbound without recreating it?

In my database, when I enter a revenue in the Revenue form, it creates a new client even though I'm selecting from the client list. Any ideas why it does that? Should I create a save button? DB is attached. I just tried a save button and it still creates a new client.