Search results

I would love to have some friendly advice. I am trying to help a coworker and she is having a problem with the Iif statement she is using as Access says it is now too long. She has a database that records donations made by trustees for two companies. Company A trustees have a budget for...

I know, everyone's favourite subject (hasdata). I actually have gotten it to work--almost. I have a main report, based on a cross-tab query. I have a subreport based on a crosstab query. I am now in the process of adding the subreport "total" to the main report to get a grand total;however...

I have a pretty big table and only so much room on one form for the information so I made another form with the remaining few field of info and used the same record number field hoping to "link" the two forms together...but it doesn't. The second form always comes up with the first record of...

I have a grant funding database. In the database, from a single funding source, I can have up to 20 Grantees (all different) funded. I've named the 20 fields, Grantee 1, Grantee 2, etc up to 20. I now want to combine these grants into one field so that I can do a reports as to which Grantee...

I have a grant funding database. In the database, from a single funding source, I can have up to 20 Grantees (all different) funded. I've named the 20 fields, Grantee 1, Grantee 2, etc up to 20. I now want to combine these grants into one field so that I can do a reports as to which Grantee...

For some strange reason I am unable to add or edit records in my form yet the form properties show that Allows Editing, Addition and Deletions all say yes. Also, when I click on my "add records"button, it comes back with an error message that says "you can't go to the specific record"

Is it possible to have a calculation in the detail section of the report that would subtract each line item from a set balance. i.e., I have a budget amount (in the page header) and in the detail section I have donations made....for each line of the report I want to have the donations made...

Here's an interesting little problem...I have a query which combines three tables. One table has payment information related to grants awarded (101 records). The second table gives the payee information (36 records). The third table gives the contract information (51 records). The ultimate aim...

I have a crosstab query that pulls data into columns headed by years--problem is that I need to define the years as our fiscal year (10/01/??-9/30/??) rather than the default calendar year. Any quick and easy way to do this?

Ok, I've finished my beautiful dbase and have set up a work group and set permissions (mostly read-only) for the staff. However, I obviously I have missed something because only one person at a time can have access to the dbase. Where and how do I switch it from exclusive mode to share mode.

Another stupid question... Is it possible to total on a number field (in a query) only if it meets a criteria for another field in the same record. If so, how do I do it (my head is getting sore from banging on the brick wall) and (there's more) if it doesn't meet the criteria, either leave...

I have used simple queries before but I am tackling something beyond my current realm of experience. I am trying to set up a budget field that will calculate the budget amount based on rate assessed to a certain parameter of dollar amounts. I.E. Grant award amount >$1,000,000 then the budget...