Search results

try this Hi If I understand right what you mean try this: Iif(IsNull(Query.[column]),0,Query.[column]) AS [column] This should change value "nothing" to 0.

Hi How is it possible to change row in query column title? I have query which look like this: [number] [start time] [end time] 1224345 12.6.2007 13.6.2007 I want that my query should look like this: [number] [start [end time] time] 1224345 12.6.2007 13.6.2007

Hi. I'am trying to count: todays date -12 month. So how I tell access that I want answer which date is year from this date? Or how I must "write" 12 months in SQL?

Yes I know that these fields are date/time fields. I only write times into my example but there really are like this: "12.3.2006 10:20". If somebody knows some good tutorial pages about VBA and making scripts whit VBA please let me know.

Hi. I'am trying to make script which counts time durations together from table. My table looks like this: [start time] [end time] [duration(min)] 12:20........13:10.......50 13:20........13:40.......20 And my query should look like this: [hour] [duration] [fault happened]...

Hi. How I can delete all rows from my table whit on query? Also I want that when I delete rows from my table index and other settings will stay in table.

Thanks. But how I should set my keys to two tables(source table and destination table). I don't understand how I can prevent adding duplicated rows to my table by using primary key.

Hi. (I already ask how to delete rows but it looks too hard to make so I invent new idea) How I can add lines (INSERT INTO) into table so that Access does not add lines which already are in the table??

Hi I have to make a query which deletes duplicate rows from my table. How I should start to make it? Can I do it whit one query or does this operation needs more queries? I know that DISTINCT works but how I can set it to DELETE operation? I have try to use command DELETE DUPLICATES FROM Table...

Hi This shouldn't be hard SQL-statement but I just doesen't got it how it should be done. I have a two queries which lists same things. One of my query1 look like this: [start time] [end time] [duration time][fault] xxx.............xxx...........xxx................xxx Now I Count different...

Hi I have query1 which shows different channels and those fault duration. Like this: [channel] [fault duration] cnn............5 bbc............2 and so on How I can make a query2 which checks from my channel table are there every channel. And if it not then adds it and set it [fault duration]...

Thanks very very much. (I try to search and think this for long time before you give me this advice)

Hi I have make a combo box which uses table like this: [month] [start date] [end date] january 1.1.2006 31.1.2006 february 1.2.2006 28.2.2006 ... When user chooses month I want that start date will be showed in textbox in form. And end date will be also showed in another text box. So I...

Hi I have a table where is listed all happened faults from a month period. Every fault have start time and end time field and ip field which tells what device has been "broken". Now I'am trying to calculate how many faults has happened in every day. I have make a query from the table which looks...

I maded it whit that visible=yes/no method. Maybe it wasn't the best solution but it work. Thanks a lot

Thanks. Now I have idea how to do it. But how I set for the command button to show the subform(VBA or some settings). And if I want show another table in same place do I have "draw" a subform in same place?

Hi I have a form which has two command buttons A and B. I set that when somebody click the button A then table A will be open and so on. But I dont want that table opens in new window. I want that I can "draw" a "box" in form where the table will showed. So can anybody help me and tell how to...

Thanks FoFa. I got it work now:)

I have been thinking same. I just dont understand why it doesen't work. Nice picture oldsoftboss:)

Hi I' am trying to make a form which executes a macro in every minute. I have put the Timer Interval to 60000ms. But now the form executes the macro only once and I want that macro will be executed always after one minute. So how I can make this work? Do I have to make somekind of loop in code...