Recent content by lumpy2497

I have created a table in a word document where a formula field will sum the numbers above it (=sum(above)). Is there an easy, foolproof way to create a button so that the end user of the document can click and have it update the sum field seeing that the document doesn't automatically update...

The user inputs are 2 different. I usually use [Start Date] and [End Date]. Leeann... :)

Thanks!!! That worked!! However, when I amend the date to go from "Between 5 and 18" to "Between [user input] and [user input]", it doesn't work. I want to eventually have it span across months, (ie. 4/19-5/2, etc), but I'll save that one for down the road. Leeann... :)

Hello All! My co-workers and I are trying to run a query to find certain employees that accrue vacation time based on their accrual date. We currently are using DatePart("m",[accrual date]) with a user prompt to get the month. But we would like the DatePart("d",[accrual date]) to only give us...

Did a bunch of research and finally found a SQL Statement that solved my problem. For those interested, here it is: SELECT Account, FirstName, LastName FROM [Client Info] WHERE NOT EXISTS (SELECT Account FROM Transactions WHERE (Transactions.Account LIKE [Client info].Account) AND...

Didn't Work Keith... Here is what I tweaked to make the tables and fields correct for my database, and it doesn't work. When I change the ISNull to "False", it gives me all the transactions that I know have happened, which should happen. When the ISNull is "true" query is run, there should...

I currently have 2 tables going: Table 1: Customers Fields: Account (join field) First Name Last Name Table 2: Transactions Fields: Account (join field) Date Payment (money that comes in) Fee (invoice that is charged) I need to find those...

Still Not Working For some reason, it's still not working... Here's what I have changed, and the error message that get says that it's looking for a delete, update, etc. The name of the table to update is: Landlord Information The field that gets updated in table is : Landlord_ID The name...

Access Version Access 2000 Leeann... :)

Questions... When I cut and paste and run it, I have an error message that comes up dealing with: ' database and recordset object variables Dim db As DAO.Database Dim rs As DAO.Recordset I gather the sense of the code, but what would I use to replace "DAO.Database" and...

That's it! Exactly!! Leeann... :)

Hi Everyone!!! Hoping someone can help me with this. I maintain a database that contains information about apartments that our business rents for clients. Included in the tables are those for landlord info (name, address, etc.) named "landlord", apartment info (address, accounts, etc.) named...

Thanks!! Thanks!! I'll try it!! Leeann... :)

Here's my quandry... I need to perform a query on a date/time field that would allow me to only see results that would happen in a specific month over a span of years. To bring this to layman's terms, I want to find all the records that were entered in June only. Year is irrelevant. For...

Continued... How would I put that expression into a report footer so that I have a total sum of those values? One caveat is that I would only need the values that are greater than 0. Leeann... :)