Recent content by techwriterAR

PRPhx, Yes, I have permission to access all the fields in the initp100c and mftxp100x tables. I cannot change or edit records in either table but I can access them. Most of the time I have to use the Data Transfer from AS400 when I need to get data, which comes in as a text file. Then I use...

Koresnordic, I do not know how to create a parameter query inside Ms Query. I use parameters in Crystal Reports and MS Access, but I have not tried it in Excel. Would you have time to explain how I would set up my query to accomplish using the current date when running/refreshing the query...

I'm trying to build an excel 2007 spreadsheet by pulling data from an AS400 database. I am writing my query inside Excel using 'Get data from other sources'. This report is supposed to return quantity of each product sold from the current date to one year back. I need to set the date field to...

Thanks CR85user, I appreciate your explanation. I tried it out and it works! It was fun testing, it helped me see what you were talking about. Gjeffcoat

I want to thank both of you, elsenorjose and lbass, for your help. The formula worked perfectly and I have my report ready for distribution. I really appreciate your help and the switfness of your reply. You really helped me out of a jam. I was wondering if I could impose on you again? I...

I have a Crystal XI Report that uses a stored procedure to create a list of late shipments. The data is stored in MS SQL and the field is a character field. When I look at the field in my report, crystal calls it a string. What I need to do is remove the number, space and dash from the string...

ClydeData, Thanks for your response. Let me see if I understand what you are suggesting. First I create a make table using the performance query. Then I use query 2 on the make table to get the final result which should have added the like-products together. Okay, I will give that a try and...

I am using Access 2003 with windows XP. I have a performance tracking db with the following fields: cellID, product code, date, qty ordered, qty received, actcrewsize, start time, end time, goal time. I use a query to calculate the performance. In the performance query, I have a formula that...

I have a query in Microsoft Excel that returns carton usage information for a period of time. I also need to list the parent product for each carton. This information is listed in 3 tables. I have created one query that returns the carton usage and one that returns the parent-child product...

Hans8823 Thank you so much for your help. I had to make a couple of changes to your code to get the result in minutes. I really appreciate your help. FYI: These are the changes I made: Public Function Shift......As Integer First Shift line from Shift=endtime-starttime to Shift=DateDiff("n"...

Hans8823, Thanks for your response! I will give this a try. gjeffcoat

Okay, here I am with my hat in my hand. I have another question. The formula PHV gave me works as long as the time does not go past 11:59 pm. When it does, I get a negative answer. What do I need to do to this formula to get the correct number of minutes that have elapsed? -------- Minutes...

THANKS PHV: Your formula worked like a charm. I really appreciate your help. Gjeffcoat

THank you PHV! Took me a while to get the syntax, but your solution works like a charm. Now, if I can get just a bit more help, I need to know how to write the DateDiff formula to subtract lunch time. Right now I have this: Minutes:DateDiff("n",[StartTime],[EndTime]). Where do I put the...

In my Excel spreadsheet, I have 4 cells set up with the following times: 11:30 AM, 12:00 PM, 9:30 PM and 10:00 PM. The formula to check for lunch1 is: =IF(f7<=$A$1,IF(G7>$b$1,30,0),0). Colums F and G are start and end times, respectively. To check for second shift lunch, I use the same...