Search results for query: *

The table on the left has a date time field. The table on the right has a date time field. I can join the two where those fields are equal. In other words, return records from right table which match the date time of the left table. How do I return records from the right table which are equal...

I believe this is yyyymmddhhnnss00 - I can do it with a function for each date/time part and then another function to put them together but I wonder if there is a quicker way... 2014102923031500 2014112605110500 2014123002252300 Thanks! I joined this forum in 2005. I am still a hack.

I have a report that I run which is grouped on Organization Name. I have some VBA (thanks to this forum) which splits this report into individual reports for each Organization and drops the reports into a folder. Each report is named with the Organization Name. Let's call this Step 1. So now I...

here is my data: I am making a form which shows the data for each FirstName. Here is the first record in the form: The problem is the "Record: 1 of 6" - I expect there to be FOUR records, one for each person in my data. I am eventually embedding this data in a report grouped by FirstName...

When I do what I think should work, I get an error: You tried to execute a query that does not include the specified expression "MealID" SELECT tblMealDetail.name, StDev([SumOfqty]) AS StDev FROM tblMealDetail; This is what my data looks like: "name" "MealID""SumOfqty" "abe" "A001" 9.00...

My data is pasted at the end of this post. I am trying to count MealIDs per name. Right now I use two queries. How can I do this in one query? First Query SELECT tblSomeTable.name, tblSomeTable.MealID FROM tblSomeTable GROUP BY tblSomeTable.name, tblSomeTable.MealID; Second Query SELECT...

I have tblDiet which contains information about food people eat during each "MealID" and I want to analyze the foods in the context of the MealID. In other words, let's say I want: 1. Every MealID where only pears were eaten 2. Every MealID where only pears and oranges were eaten 3. And the...

I start with data that looks like this (I do some cleanup in Excel to get it like this): ID,RecordID,Field1,Field2,Field3,Field4,Field5 1,ABC_001,this,that,,, 2,GER_056,that,other thing,,, 3,HTR_895,stuff,nothing,more stuff,blah, 4,RTZ_456,that,more stuff,cars,trucks,vans I turn it into this...

I get data like this: 0 hours, 7 minutes 0 hours, 44 minutes 1 hour, 53 minutes 0 hours, 1 minute I want to convert it to decimals. Right now I use Text to Columns, Find/Replace to get rid of the hours and minutes text, convert the minutes to a fraction of an hour, and then add the two columns...

I need to rip the last name out of a username field. The username is formatted First Initial, Last Name, and an incrementing number for uniqueness. eg: USERNAME jsmith jjones jsmith1 rlove I am really close with: Last: Right([username],Len([username])-1) But I need to strip the number off the...

I have simple data in tblLog; three fields - Username, DateTime, Action What I want is to return the "next" action for each user based on date. The notes I jotted for how I think this needs to be structured is: Select Action for Min DateTime where username = username and DateTime > DateTime I...

I have this VBA that loops through records and splits the printing of a report based on the LoopedField. I need to add date range parameters to the underlying query and I want to store the date values in a form. When I change the Const Domain to point to the query with the date parameters I get...

I have data from a user log, it spans multiple days, contains information about multiple users, and records a variety of actions. As user logs are known to do, this data records what a person did and when they did it, over an over. Since I can tell what they did and when they did it, I can tell...

There are many ways to do this and I have tried a bunch. None of them are working. This was my latest attempt and, while close, is not getting me what I want. 1) I am getting a few null results that I cannot reconcile and 2) The "DifCalc" result is formatted as a date - I want hh:mm:ss. Or just...

I have found many threads about this topic on many other forums, and a few here on tek-tips. I have tried a bunch of snippets of code from various sources but I cannot get any of them to execute. I run a report called "rpt_qrySPU03" It is grouped on a field called UserOrgInd I want to print the...

This is making me a little bit batty. I am getting to the point where I am about the blame the computer. I have a really simple table that I am trying to import by appending the data to an existing table. The existing table is set up with the correct fields. I have one field that is causing...

I have two tables that I want to relate. tbl_1 contains USERID, DATE, TIME, LOGIN_LOGOUT tbl_2 contains USERID, DATE, TIME, EVENT_DESCRIPTION For example: tbl_l c00014;12/23/2013;12:07:22;login c00014;12/23/2013;12:12:08;logout c00014;12/23/2013;12:20:23;login...

I have a combobox where the available entries are supposed to be dependent on another combobox. My problem is that when I put this form on a subform by putting it in a tab, I get an error. This combobox works when it's not in the tab of the subform. The row source for the dependent combobox...

I have an update which is very simple: UPDATE export SET export.level_2 = "20100527", export.level_3 = [level_2], export.level_4 = [level_3], export.level_5 = [level_4], export.level_6 = [level_5]; What I want to do is run this query from a form. The problem is, I cannot update using the...

I have document paths, including file name, in a PATH field: MyDocs\Pictures\honeymoonIsOVer.jpg MyDocs\WorkStuff\Accounting\Quarterly\FakeInvoices.xls MyDocs\HideFromTheBoss\NotPron\specs.jpg So, the folder structure will vary, but the text I am looking for is everything after the last...