Search results

Hello everyone - I have a query with 4 Fields (Category, Time, CategoryCount, and Date). I want this query to group by category, Sum the time for the category, display a count of each category. If I remove the Date field from my query, this will result in pulling all the information in my...

@FSmith - I'm going to attach a screen shot of Brian's example for you. I used age 47 and 29 as my example birth dates. @Brian - correct me if I'm wrong, but the date format is dependent on how you have your date format set up in your table, correct?

I didn't read all his question apparently :). Makes sense though Brian.

I just tried this query and it works. But one thing is, is that this is an Approximate age. If you would like to calculate Accurate Age you could use this... Age: (Date()-([DoB])/365.25

I am still pretty new at access myself, but I think you could do something like this. Click the Query Design > Add your table that contains your Date of Birth field. In the column next to field type something similar to this Age: Year(Now())-Year([DOB]) ' Replace [DOB] with your field for...

Haha you are right. Definitely not simple but it worked :). I appreciate your time helping out.

Well after thinking about this I ended up writing something that performed a count. Here was my code that I ended up writing. TotalRecords...

Hello everyone, I have a form with let's say, 10 numerical fields on it. The user may or may not fill all of these fields with data. I need to come up with a query that will count those records with data in them and not the null fields. Currently the values of each of these fields is 0. This...

I have a database that keeps track of training sessions here at work. This database has 2 tables (Associate and Training). The training table has multiple records for the associate. Every once in a while we have meetings where it involves the entire staff. I want to be able to have a way where...

Ok Well this was pointless of me to post this on here because I have figure it out myself. Here was what I did to resolve the problem in case anyone out there runs into this problem. In my table with the date I had it set as a TEXT type. This was a mistake, as we know it's a date/time field...

One thing I do notice while playing around with this is that this has to do with the CDate function. If I don't convert anything using CDate, then I get all the same data apparently.

Good morning, Let me start with this .... :banghead: I am trying to do a simple query that pulls data from a date range using the BETWEEN operator. Simple right? Apparently not as simple as I thought. So I have 4 fields I am pulling info from. RSID, PCounty, Type, and RDate. For the date...

I like that way a little better too. Thanks for sharing!

Actually I went one step further with this if anyone ever needs an example. So I needed a date range between 12/13/2011 and 12/12/2012. But each year this is going to change, so I wanted the year to update as well. The month and day will always be the same unless the State changes this for my...

Nevermind I figured it out myself. I ended up using the DateAdd function. To get a date I wanted I just used something like this... DateAdd("m", 0, "12-Dec-2012")

Good morning everyone. I have a question reguarding a pre-selected field. Currently on my form I have a Start Date and also a End Date. After you enter the 2 dates then you can print the report that the form is set up for. The textfield is set up to either allow you to type in the date or...

I really appreciate all your help vbaInet. I'll keep tinkering around with things until I get this figured out. Have a good day.

Actually that was what I googled before I came to this Forum. I tried my SQL but I couldn't get to perform the way I wanted to. Here is my SQL. SELECT tblAssociate.AssociateID, tblAssociate.FName, tblAssociate.LName, tblTraining.TrainingID, tblTraining.TDate, tblTraining.Hours, [LName] & ", "...

Well here at my job every employee has to have so many hours of training in a year. I want to be able to show all the employees reguardless if they have 0 hours. The reason being, is because an employee MUST have a minimum of lets say 10 hours a year. If I'm looking at the report and see that...

I have a Form that allows the user to select a date range for an Associate's total Training Hours. After they select the date range the user can select a button on the form that says something like "Get Report". Everything is working as intended. The total training hours is displayed by the...