Search results

I have a financial report that I have three levels of grouping for monthly expenses. Depending on how the transaction was created it can have some of the groups that contain no data. So here is are my groups Account - will always contain data Operating Unit - will not always contain...

Here is a screen print of the input form in design mode. I'm going to get with my IT guys today to see how they would grab the username.

I'm not getting anything to show up in the createdby field. I did notice two new fields that showed up on my form and wondered it there was something that I could with them. One is called System Name: and another called System Id Number:

I see what you are talking about but for some crazy reason that field I updated. So what do you think I need to do for the username?

I have created two tables in which I want to track who and what time data is entered and then again if the table is modified. I found this code which I added to BeforeUpdate: Private Sub Form_BeforeUpdate(Cancel As Integer) ModBy = Environ("username") ModDate = Now() End Sub Private...

Think I'm missing something?

That's looks perfect. This is just a quick fix for something that will be collected on a bigger scale once an upgrade is finished. Thanks, you have shown me something new!!!

Here is how I would want it to look.

That would be a column header "Method(s) of Customer Notification" in the report. I looking to have the fields below show in that column: Nixle Twitter Media Radio Personal Contact Phone These are setup as yes/no fields.

I might add I would like the column in the report to read "Method(s) of Customer Notification" and the data to shows as follows "Nixle, Twitter, News Media". So if more than method was used all will show. Thanks for looking at this for me.

I have a database that has a field for methods of sustomer notification. I created a form which shows the top methods within our community. Is there a way to have all of these show up as text within a report? Maybe there is a better way to set this up to begin with but I was on a short...

Yes, Yes!! That now works. Thanks. Small things sometimes get in the way of progress. Do you think I can create another query that could include employee and task. I going to try a union to see if I can get that to work. What do you think?

Look closer at the subtotals qry Pay Period linked to Current SumofHours = 1,164 SumofRate = 48,519.19 These are correct. qry Summary All AllHours = 11,635.63 AllRate = 348,648.88 These are correct. qry z Final AllHours = 116,35.63--Correct AllRate = 348,648.88--Correct CurrentHrs =...

Your queries are doing the same thing mine are. Individually they work it’s when they are combined into one query they go crazy. I have tried to change the joins and the fields that they are linked by. It just doesn’t want to work.

The pay period is a two week period. So there will be 26 in a year. I pickup the pay period in our payroll system so I don't need to worry about dates. The value has been set in the tblValues

Sorry I got pulled away from this for a couple days. Thanks for looking into this for me, but your last query does not bring back the correct totals for the current pay period. This is the same problem that I was having. The queries that you created for the pay period and the total work by...

Here is a copy of my database

Here is my SQL behind the query. SELECT [qry By Pay Period].Employee, [qry By Pay Period].SumOfHours, [qry By Pay Period].SumOfRate, [qry Project Report].Hours, [qry Project Report].Rate, [qry Project Report].Project, [qry Project Report].Task FROM [qry By Pay Period] INNER JOIN [qry...

I have a database that collect time and costs for projects. I have a query that looks like this. tblData.Employee tblData.Hours tblData.Rate tblData.Project tblData.Task tblValues.Pay Period I trying to get a current pay period and year-to-date for the hours and rate. I able to get the...

I have been using Access since version 2002. I really should be better at it than I am. With the help of books and fourms like this, I have been able to put together many databases to help me and other get their jobs done better and faster. I can read SQL much better than I can write it...