Search results for query: *

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

Hey all, I'm building a query for a Cycle Counter to sort through pick zones. He wants a query that you can use to remove Pick Zones that are scheduled. There are over 30 zones, if there are 3 scheduled, he wants to be able to type in the 3 zones that are scheduled, to show him all of the...

I wrote a script that restores all files on each volume group and appends it to a file. This way you can view what was restored on last night's tape. We ran this over and over and discovered that the restore process wasn't stopping, so there were hundreds of process hanging out there. I'm...

I have a form on a database that keeps track of work orders. Once a week our tech comes in to fix our Scan Guns and we enter the fix date on the work order. Every Monday my boss wants to run a query to see how many guns were fixed on the most recent date. The tech doesn't come in on the same...

We're trying to open a very important Database that we use everday at our facility but it is giving an error Microsoft Jet Engine could not find object "MsysDB". Does anyone know how to go in an repair this database or does it have to be restored? Thanks a lot. Jason Alge...

I'm trying to import a bunch of tables into access using a marco. This will be done as an autoexec when everything it completed. Anyway, the files are called wavelog20040410 (YYYYMMDD) These are files brought over from our RS6000 weekly. Anyway, I'm trying to import them all into 1 table, and...