Search results

No, no action queries. Just a form that is linked to a table. thanks.

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

thank you!

thank you both. the database is almost 7MB and it's MS Access 2003.

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

OK, this is exactly what I need!!! thank you so much!! Scott, thank you for all your help, really really appreciate it!!!!

Scott, thank you so much!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! this works great!!! The only thing is that it doesn't show one of the Employees - John Willey. It looks like it picked up Amy Smith because she doesn't have ANY hours, so she would be considered Null I guess. But John Willey...

I replaced Hours.EmployeeID by Employees.EmployeID and my results still don't change... I'm attaching the database, the query is called qryHoursSumPerPayPeriod. I really appreciate all the help, thank you.

I changed the Grouping to Employee as you suggested, and when I run the query here's the error message that comes up: You tried to execute a query that does not include the specified expression 'Employee ID' as part of an aggregate function. Any ideas what else I can do or what am I doing...

I tried Outer join, but no effect. I tried Right Join, Left Join, Left Outer Join, but my results don't change... I need ALL records from Employees table and matching records from Hours table. Here's my SQL: SELECT Hours.[Employee ID], Employees.[First Name], Employees.[Last Name]...

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

Here is the database. I also need all the Nature of Work displayed in the results. so far it's just picking up the ones that have hours. Similarly to Employees. Thank you for all your help!

I tried that and it didn't change the results - I still only get the Employees that have hours and not all the employees... any idea why or how else I can do this? thank you.

Thank you, I tried the crosstab query and it works beautifully. I have another question though... I'm grouping my results by Employee Last Name and displaying the sum of Hours for each Nature of Work. However, if a certain employee doesn't have any hours, that Employee doesn't get included in...

Thank you! when you say "Change hours to total" you mean change it to "sum"? I tried this and it almost works. It does sum the hours and groups by employee and the nature of work. However, if one employee has several natures of work, it will list it as a separate record, therefore repeating...

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

Thanks Scott! I have a question about the form. Should I create a new table that will hold the date and the count fields for the form?

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

Thanks for everyone's help! DanG's query worked beautifully! The only thing it does not group male and female counts into one record. For example, if there are 2 males and 3 females in Maine township, what it shows is this: 2 males; 0 females; maine township 0 males; 3 females; maine township...

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