Search results

I'm trying to write a query to figure out the time something was delivered. I have the following information to work with: Estimated arrival time: 13:00 Loaded Time : 14:00 Trip Time : 2.5hr - - how do I conver this to Hr's & Min.? I need to subtract the ETA...

Any ideas from anyone?

I'm trying to run a query that has a 3 expressions within the query. I'm using the following: Exp2-Exp1 this would be the results for Exp3. The problem I am having is that I only need the results for Exp3 to be returned if they equal "0". Any help would be appreciated.....Thanks

I need to know if there is any way to password protect a single query. I currently have a database and there are several users that have access to run queries but I need to have some security as others are making modifications to queries that they shouldn't be.

Perfect.....thanks

How do I run a query so that I do not have to keep changing the date. I want to run a query everyday but want to use the date from the day before. I want to use yesterdays date for today and then todays date tomorrow. Thanks.

I am running a query which returns daily sales numbers a also calculates a percentage increase. The query works fine until I try entering criteria to give any percentages that are >150 or <50, when running this no results are returned. Any help on this would be greatly appreciated. Thanks.

I'm using several tables in my query and trying to use an "IF" statement in my expression to return a result. For this expression I am using the information from 2 tables. Cust # INV Date Disp. Date Order Number Dispatched 52025 jan 17 jan 17 12345...

I have a query that i run and now I am adding another column to provide a ETA for an order, when i specify a date I only get results that have that date and when I leave out the date I get too many results. Can someone please let me know how I can modify my query so that I get all the results...

Yes, I would like to have the dates print on the report. The dates would actually be the Headings for some of the columns.

How can I create a report with a screen that pops up where I will need to enter a start date and end date as these dates will have to change each week. Thanks, Scott

I am trying create a report from a query and I am using serveral dates in the query. When the query or report is run the dates are displayed in a column. Is there any way that I can have the dates displayed in rows. This is what I get: jan 1 jan 2 jan 3 jan 4 This is what I want: Jan 1...