Search results

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

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

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

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

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

Hi All... here is my quandry: Here are the fields that pertain to this question- Gas - currency, 2 decimal places Electric - currency, 2 decimal places Misc - currency, 2 decimal places Budget - currency, 2 decimal places I need to create an if-then-else with the IIf statement, and for some...