Recent content by jalge2

I'm trying to figure out how many trucks we have had come into this facility in the last 24, 48, and 72 hours. I have a Date/Time Field with data showing 1/10/2005 6:00:00 AM What do I put in the criteria to look back a certain amount of hours? Thanks for the help. Jason Alge...

I have a command button that imports text into a table. The code is called Import_New_File_Click (). I'm trying to get that code to run from a macro but I'm not sure how. I copied that code into a module and saved it as Module 1. I can't get the runcode in the Macro to run this module...

Golom that worked great. Thanks for the help. Have a star. Jason Alge Jason.M.Alge@lowes.com 'There are three kinds of people: Those who can count and those who can't'

I have a table with one of the Fields containing the Date/Time. I'm running a query where I only need the Date pulled out. The way that it's been working has been with this string ADDED_DATE: Min(DateValue(Mid$([caroship table]![added_date],1,10))) I'm unsure why but I keep getting a Data...

I am having problems with a query that has been used for quite sometime now. The query should never have been changed because it runs off of a command button on a form. Anyway, what I am having problems with is this line... ADDED_DATE: Min(DateValue(Mid$([caroship table]![added_date],1,10)))...

That worked Dr.Simon. Thanks a lot for the help. Have a star. By the way, misunderstanding is my trademark. :) Thanks again. Jason Alge Jason.M.Alge@lowes.com 'There are three kinds of people: Those who can count and those who can't'

Thanks for the help. I put what you gave me into the module in two places. I tried to run the code, but still received the error saying that it couldn't find file 20040105.txt (which I took out for test purposes). Here is what the code looks like in those two places. If...

Hey all. We have a database that we use to import text files. The naming convention of the text files are as such: January 4th, 2005 would be created as 20050104.txt These files import into a database. The files are created only if there is activity going on, so on Christmas and New Years...

Select Carton, Area from qryfinalDedicatedItemsPickingInBld Union Select Carton, Area from qryCartonsinMods UNION Select Carton, Area from qryTotalCartonsinPrintedStatus; Above you will see my SQL Query. Hope that helps. Jason Alge Jason.M.Alge@lowes.com 'There are three kinds of people...

The percentages of picks in the building as compared to the total. Mods 13000 Percentage 10% Perm 5000 Percentage 3% Total Picks 130000 Jason Alge Jason.M.Alge@lowes.com 'There are three kinds of people: Those who can count and those who can't'

I've built a Union Query that pulls counts from 3 different queries. I placed those 3 counts on a report but my boss wants the percentages beside it too. The output is this Building Picks 130000 Mod 13000 Perms 5000 I need the percentages of the picks that are...

Hey all, I'm trying to set up a Union Query and I've got a couple of questions for that. First of all, all three queries are doing a Count of something different. So my series of questions are this... Can you set up a Union Query if all 3 Field Names are different? If so, how? If not, how...

The only way I think would be to do a Union Query, but I've only seen that done once, and really have no clue how that is performed. Jason Alge Jason.M.Alge@lowes.com 'There are three kinds of people: Those who can count and those who can't'

Hey all. I've got 3 queries that I'm trying to put together into 1 report. All I want is to be able to add 3 text boxes to a report and make the control source of each text box = the Field in the query. I tried to use the expression builder but that is giving me a #Name? Does anyone know...

Hey all. I have 3 tables that have 1 cell of information in them. It's a total put together from a query. I'm trying to find a way to get them onto a report but I'm having problems. The control source for each text box keeps coming back with errors. I've tried to use the expression...