Search results

Hi. I didn't do in SQL. I just used the query grid.

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

Thanks for your help. It turns out that I have to save the form or hit the return key after I enter the dates into the unbound text boxes. It works fine.

I should add: when I do it the old way, Between [Enter start date] and [Enter end date] it works. But it would be so much easier if all the queries could just pull the same parameters from the form.

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

I got it. Instead of picking from the list I needed to hit the ellipses. Thanks for the help.

Thanks, but white isn't a choice. No colors. The choices are: Alternate Row, Background form...

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?

Definitely. Thanks.

Hey Markk... figured it out again... not very difficult... sheesh!

I got that to work earlier, but can't now. I have a date filed named "Date." I want it to show just the numeric month. Trying to follow the example table: The field is named "Date" I can't see what part of the statement is point to the field. Should it say on the field line...

I've been designing databases for decades without "writing code." I took a VBA course once a long time ago, but didn't use it enough to make it stick. Access writes the code, I presume.

I'm not writing code. I have a table storing emplyee ID, work date, and hours worked. The employee ID is a lookup field that looks up the name from a Roster and is supposed to display the name and store the SSN. On some it displays the name, and some the employee ID. All of the records in...

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 ultimately made it work, by making the month one field and the year another. Then I sort first by year, then my month and they come out in order. Works fine and gets the right results. When I join the two fields (e.g., 2015-6), Access again sees it as a text.

This worked!!! Thanks.

Markk, I get the month/year using the query wizard.

The raw data is a date field but not the 1st day of the month. None of my dates are in text fields. The field ACCESS creates as the month/date field is a text field (or appears to be). It's the field that only sorts alphabetically. When you say "I would use the first day of every month to...