Search results

Hi, I'm running a simple query joining two sets of data. They are joined on 2 fields. The table on the One side has a total of 59 records, the table on the many side has over 200. Only one record on the Many side might match with a record on the One side. Despite there being no records to...

I have a form on which I want to put a tool for the data entry staffer that calculates elapsed time after they enter times into 2 unbound text boxes. We don't want that person to put start/end times for each record. We want to enter just the elapsed time so they need to calculate it. I have...

I'm not sure what the problem is with the expression, but it's not working even though I used the expression builder to create it. I'm doing a range of calculations on hours worked by project. To do this I create a query with Total hours for the period, and another for hours by project. I then...

I designing a report that gets its data from a query. The query is a simple join of two tables: one with staff IDs and demographics, and one with Staff IDs, pay date, project, and percent of time allocated to that project. There are 1 to 5 records per employee per pay date. When I run the...

Hi, I've designed a report and ACCESS decided it needed background color. I have no idea why sometimes it does and sometimes it doesn't. But that's not the problem. When I go to properties, and background color, "no color" is not available. How do I get rid of my that background color?

I have a query I run on an employee ID lookup that displays the name. When I run a query some of the fields show up as the SSN, but most show up as the name. I have a sub report that is linked on that ID, but only those that come through the query as SSN, link to the report. Why are some of...

I created a query that sums hours worked by month. When I sort it in the report, it sorts alphabetically instead of by date. How do I fix that? Thanks.:banghead:

I'm designing a tool for staff to enter hours worked on a project by dates. I want the data to go into a flat file, and I'll do cross tabs for analysis. But the users are accustomed to doing this in a spreadsheet with Dates across the top, and projects down the rows. I'd like to design a form...

I was first introduced to databases in 1987 with Paradox - a nice DOS based and powerful relational database. I started using ACCESS a few years later. I was working as an economic analyst and used it to analyze the housing market, labor forces, and other data. I later used it in my work in...