Search results

I have a table, tblFees, that has the following columns: ID = AutoNumber AccountNumber = 8 AlphaNumeric digits FeeChargedEffectiveDate = Short Date DateEntered = Date and Time I'm using the following to count how many times an account number chosen from a user form appears in the table...

Thank you for your response. I spent some time laying this out before i got started. I had hoped i did not have any design problems but I guess that is not the case. From what your saying I believe I need to add a RepNumber field to the tblRelationships. I had originally not done this...

I found a work around that seems to be working. I'm sure there is a better way. me.cboExistRel.value = DCount("[tblRelationships.Relationship]", "qryRelationship", "[tblRelationships.RelationshipID]<=" & _ DLookup("[RelationshipID]", "qryRelationship", "[Relationship]='" & Me.txtNewRel & "'")) - 1

That does not seem to work. "Record Number" is not a defined column in qryRelationship. If you run qryRelationship and select one of the records the number that shows at the bottom is what I'm referring to as Record Number. I tried this DLookup("Record Number", "qryRelationship"...

The problem that i see is that cboExistRel.Value is the Record Number from qryRelationship. The Record Number and the RelationshipID do not correspond. Is there a way to lookup the Record Number from a query.

I did a little digging and I think i partialy figured it out. cboExistRel is getting its values from qryRelationship. If I use cboExistRel.value = 90 it shows the 90th entry in the qryRelationship. The dmax doesn't help because the query is alphabetical and is trimmed depending on who owns...

I've got a user form with the following cboNewOrExist = combobox for selecting New Relationship or Existing Relationship txtNewRel = text box for entering New relationship name. cboExistRel = Combobox for selecting Existing Relationships txtNewRel is only visible if cboNeworExist =New...

Thank you all for your help, Plog had the best solution for me. I changed some of my Field names to help me. I also setup a user form where I can select dates, the user form runs a Query called Monthly Production which runs another query called Production Query SELECT DISTINCTROW...

Thank you for your help, the date column is named TradeDate. Assume January 2016 is 12/16/2015-1/15/2016 and February 2016 is 1/16/2016-2/13/2016 Trade Date Bucket Revenue 12/16/15 1 $50 01/10/16 1 $25 01/14/16 2 $30...

Just to confirm, remove the Start Date field and use > and <= on the end date? Still don't know how to get the rest of this done.

I have a db with a couple of tables. Production ID, Date, Bucket, Revenue Production Calendar ID, Start Date, End Date, Business Month, Calendar Year Our monthly business does not go on calendar months. It ends on the next to last Friday of most months. I created the Production Calendar table...

Bump......

I'm using Access 2010 and making a web database for sharepoint. This is my first time with this and with the elimination of many of the features i'm use to it is taking longer than I expected. I have a table with Employees listed in it. That table has a check box field for Active or Inactive...

Wow, this is all becoming a little clearer now. A few questions... 1. In tblOpenClose I can't picture how your recommendation is going to work. I might not have been very clear in my original post. In my current data. I have the following fields. Open, Close, Open Amount, and Close Amount...

Moved discussion to tables: http://www.access-programmers.co.uk/forums/showthread.php?p=1228328#post1228328

I'm continuing a post that I had under Queries but it turns out it is a table issue. Link to other post:http://www.access-programmers.co.uk/forums/showthread.php?p=1228190#post1228190 I have created 4 tables now tblPOS tblOpenClose tblBartenders tblBartenderTips tblPOS has the following fields...

I read the article and it makes since. I could see how I could split this into 3 tables with an additional look-up table. I can't manage to wrap my head around how to break it down past that point. Like the article said it is more "Art" and I must say I am not the most creative person...

I have a db with just 1 table. The Headings in the table are as follows: ID Business Date Food Sales Liquor Sales Beer Sales Daiquiri Sales Wine Sales T-Shirt Sales Tax Comp Disc Visa American Express Discover Master Card Cash Paid Out Cash Paid In Total Cash Donation Gift Certificates Open...

It is very frustrating that the fix was this easy. In design view I right clicked all the way at the bottom of the Total Product field. I then selected properties and in format I selected currency. Still need help getting the dates from the Form into the query??

I am using access 2010. This is very strange I put you SQL code in your sheet and the total product was formatted. I cleaned up my SQL and I still have the same problem. My SQL View SELECT [Forms]![BetweenDates].[StartDate] AS ["Start Date"], [Forms]![BetweenDates].[endDate] AS [End Date]...