Search results for query: *

Is ExportWithFormatting not getting you want you need?

If I add activity the results seem just as wonky SELECT tblMyTable.Name, tblMyTable.Item, tblMyTable.TheDate, tblMyTable.Activity FROM QryFirstQuery INNER JOIN tblMyTable ON (QryFirstQuery.Activity = tblMyTable.Activity) AND (QryFirstQuery.Item = tblMyTable.Item) AND (QryFirstQuery.Name =...

After some head scratching I discovered that my code above is NOT working. So here I am to ask the question again. In essence here is what I am looking for - I have a log which records events for users. It records Name, Date, Item, and Activity. What I want to do it identify all records where a...

Here is the code. I added the BETWEEN and things are working. SELECT tblMerged.ID, tblMerged.user_name, tblMerged.item_name, tblMerged.DateTimeMerge, tblMerged.qty, tblMerged.xact_dati, tblMerged.xfer_type FROM qryWasting INNER JOIN tblMerged ON (qryWasting.item_name = tblMerged.item_name) AND...

I realized that I asked the question incorrectly and that I am not joining on date, rather joining on two other fields and using date as a HAVING criteria. I am going to try putting BETWEEN in my HAVING criteria; I think that will work. As for the multiple records question - I am essentially...

Well OK! Thanks.

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

nvmind - got it: DateTimeMerge: [TheDate] & " " & [TheTime] derp

I have MajP's code and stronm's code both working. I chose to use strongm's because it combines the date/time and I ultimately want to subtract 6 hours from these date/times. How do I combine MajP's TheDate and TheTime to create one field that I can subtract 6 hours from? I tried...

Thanks, this is super helpful. I have not used DateSerial before so thanks especially for that!

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

OK, I fixed it. I created a Group By query with my FirstNames and I used that as the record source for the form. This allows me to cycle through FOUR charts. My next problem is getting this to work on a complicated report with a bunch of subreports. Crossing that bridge soon. I joined this...

That seems odd... But let's say that's correct. I suppose the next question is how do I filter a chart to show only the data for one FirstName in such a way that I can drop it into a form or report which is grouped by FirstName. I joined this forum in 2005. I am still a hack.

The charts don't change. So the "Mike Chart" is the "Mike Chart" - the two iterations are the same. I just want one. Here is a gif: I joined this forum in 2005. I am still a hack.

It was to me. I joined this forum in 2005. I am still a hack.

The name of the PDF file is the same as the value in the textbox" I had this situation once and I created a new field where I prepended my path to the front of the "value in the textbox" and I appended ".pdf" after the "value in the textbox." I made that field a hyperlink and clicking it opened...

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

Thought I did... thanks for the remind. I joined this forum in 2005. I am still a hack.

Thanks PH. Figuring this out and adapting it is going to save me a lot of time! I joined this forum in 2005. I am still a hack.