Search results

Thanks for the info Gina, But I am using a C# application that uses that database, but occasionally I need to enter to the file and made modifications like adding a new column to a certain table, actually I am suppose to be the only person authorized to do that, however, someone may opened it...

Hello, I have an access file in the shared folder in the intranet, some guy opened and I think he tried to design something, so that, the file is exclusively opened somewhere in the office, there are a lot of computers, so I don't know who is this guy, but the file is like that since yesterday...

Hello, I have an small application C# that uses an Access2003 file that is in a network folder location. We have been using Windows XP with this application and everything was fine. However, we got new computers with WindowsVista the application runs fine in those computers with Vista, but...

I could not paste the image. Two lines come out from Table1. One line for Table2 and other one for Table3, there is a "1" for Table1 and there is a infinity symbol for Table2 and Table3 and the end of the lines. So that, the main Table is Table1 where ODT is the primary Key nor repeatable and...

Sorry my friend I have made the corrections, if you reload the page ...

Here it is the complete query, some notation may not have sense for you but the database was already created when I started to work with it. Table1, Table2 and Table3 has a common relationship called "ODT" (WorkOrder), but Table3 has a column called "TDate". I want to show the ODTs that are in...

Actually I am doing it like that, that's why I am saying that still can see in the SELECTION query some records with DATE >= 2010 when should I be getting only DATE < 2010

Thanks, actually I have been trying that feature but I have a more complex situation now, I would like also to limit my query using a second column in Table2 that has the Date where the WorkOrder was started. I would like also to narrow down my result to those WorkOrders that started before...

Hi, I have a Table1 and Table2. They have a relationship with the column "WorkOrder". Table1 has all "WorkOrders" and Table2 has most of them (but not all). I would like to delete from Table1 the "WorkOrders" that are not in Table2. I think it would be something like that but I am not sure...

By the way, I need to use also "TOP", I mean: SELECT TOP 50 WorkOrderNumber FROM MyTable WHERE HourPlan > 10 ORDER BY Date

Hi, I have a query for selection, for example: SELECT WorkOrderNumber FROM MyTable WHERE HourPlan > 10 Because I have duplicates of "WorkOrdersNumbers" in MyTable, the query gives me more than one row of a simgle "WorkOrdersNumbers", what should I add to the query to make sure it is only...

It looks that it only works for "integers" if I use doubles it does not work ...

The operation "HrsAct / HrsPlan" will calculate the percentage of overloaded working orders. The point here is that in the query I have an aritmetic operation that gives me an error if I do "4.5 / 0". The overload error. How can I handle this exception in a query? By the way HrsAct and...

Hi, I have a query where I am making an arithmetic operation: SELECT * FROM MyTable WHERE HrsAct / HrsPlan > 1 AND USER = "John" It works sometimes, the problem happen when HrsPlan = cero. I tried to do: SELECT * FROM MyTable WHERE HrsPlan > 0 AND HrsAct / HrsPlan > 1 AND USER = "John"...

Hi, I have two tables, TABLE1 that has a column "ORDER_NUMBER" (the primary key) and I have a second table TABLE2 that has also the column "ORDER_NUMBER" these two tables have relationship between using these two columns. However, I have "ORDER_NUMBER" entries in TABLE2 that has a special...

ok, just one question: TOP 50 would consider the date in that the row was inserted? I would have a column date named "InsertedId" It is to say, the user would insert today a row, but the user would enter the inserting date by hand, in a field, Would the "TOP" command take care of dates as well?

Hi, I would like to select last 50 entries for certain table, this table has a primary key a string and it has also the date for insertion of the entry. What would be the SQL query to select the last 50 inserted rows of the table?

I have a table that has the primary key a string, I would kike to select the rows that starts with certain chars, for exaple if I have the following entries: P1234 P5647 12324 R4563 P4321 I would like to select those that starts with "P": P1234 P5647 P4321 What would be the query?

I would like to use: WHERE MyDate1 = MyDate2 But sometimes this dates will have different hours, minutes and seconds, so that, I would like to make the comparison only with the Day, Month and Year only. can I do?: WHERE DateOnly(MyDate1) = DateOnly(MyDate2)

Sorry, I am using C#, by "MyDate1.AddDay(1)" I mean that I am adding one day to the MyDate1, so that, If I have MyDate1 = "01/02/2011.15:20:12" by adding one day would be MyDate2 = "02/02/2011.15:20:12" By the way, how can I mark as a thread as answered, can I do that? or the moderators do.