Search results

We have an MS Access 2003 database, which is accessed by several users that enter data, but usually it's one user at a time. I've been getting complaints about users entering data and then if we check for it later, it's not there. It seems to happen randomly and not to all the data, just a few...

I have an Access database that's on our in-house server. This database has never been compacted/repaired. Recently our server crashed (but we were able to retrieve the database). Does the fact that the database has not been compacted have anything to do with the server crashing? Could that have...

I'm joining two tables in a query. I need to have all names from one table appear in the query results, even if those names don't appear in the joint. I checked the second option in Join Properties to show ALL fields from that table, but when I run the query I only get the names where joined...

I have two tables - Hours and Employees. Employees table has these fields: EmpID, and First, and Last name. Hours table has these fields: EmpID, Hours, Funding Source, Nature of Work, Pay Period I need to produce a report or a query that will display these results: A column with a list of all...

I have a database with a list of clients, their enter and exit dates. I need to do a query that will count how many clients we have on a specific date. Keeping in mind that clients leave. I can do a query that will prompt user to enter a date. However, how would I count the total number of...

I have a table that contains the following fields: township male - yes/no female - yes/no number of kids I need to create a query that will give me the count of males and females and sum of number of kids - all grouped by township. I have created 3 separate queries that calculate each part...

Hi, I have a table with fields - Client ID and Funding Source. These fields are already filled in. I created a form where users can enter some additional information for each Client ID. What I'm trying to do is when that form is opened and Client ID is selected, I need the input box that holds...

Hello, I have two fields - beginning income and ending income. I'd like to calculate percentages for those two fields. In other words, if income increased for example, I need to know by what percent. Does anyone know how this can be done? Thank in advance for any help.

I'm trying to create an online form that is connected to an Access Database. The data from the form is supposed to be collected into the database, however when I press submit, I get an error message that says- [ODBC Microsoft Access Driver] Cannot update. Database or object is read-only...

Hello, I have multiple queries that I need to display in one report, I was wondering how I can do that? Also, I need to total some numbers from those separate queries - how can I connect the data from several queries, so that I could total some of the fields? Thanks in advance.

Hello, I have two fields, one contains start date, the other contains end date. Is there a way to construct a third field that would display the number of days between those two fields? For example, start date is 01/04/2004, end date is 01/14/2004, I would need the third field to count and...

Hello, I have 5 separate queries that contain similar info for 5 separate categories. I need to create one report that contains data from all those queries. Is there a way I could do that? I would need the data to go across, from left to right, and then have totals calculated at the end last...

Hello, I have 5 separate queries that contain similar info for 5 separate categories. I need to create one report that contains data from all those queries. Is there a way I could do that? I would need the data to go across, from left to right, and then have totals calculated at the end last...

I cannot open a database that I've been using for a long time now. I get this error message: "Unrecognized Database Format". Even though it always worked fine before and it is an .mdb file. Does anyone know what is the problem and how can I restore the database??? Any help would be greatly...

I modified my startup to not display the database window, only a switchboard. However, now I cannot get to Startup menu at all - Startup does not appear in one of the menus on top. How do I restore the Startup menu to make additional changes to it?????? Thanks