Search results

Is this kind of IF statement possible in excel? I need it to do the following: If A1 = "No" then do this formula, but If A1 = "Yes" then do this formula. I am unsure how to proceed with this, it is my first if statement in excel!

Hello, I cant figure this one out, its probably really simple too.. :mad: I want this: SQLQUOTES = "SELECT SUM(Value) as QuoSum FROM Jobs WHERE Active='True' OR Active='False'" ... to only return results where QuoteDate = this year only, 2010. I would also like to know how to return for this...

Please help me! I have been trying this forever and I cant make it work. I am new at sql and everything. I just want to connect to my sql in asp. I have looked everywhere and even bought a book but It just will not work. I have tried hundreds of combinations because there seems to be a million...

Hey! I have a stored procedure on my DB, a query with the following where clause: WHERE (Job = @Job) This asks the user for a job number... but how can I simply use the value of [Job] for the record that is being viewed?

Hey all, we have a command button called [activate] which goes through a number of processes, asks for some values, sets some fields to true etc... I am wonder if it is possible for me to add the creation of a folder to these processes. Lets say I want to create a folder using [Job] as the...

How can I achieve this? I want to: Sum the [Value] field, where [Active] field is True, OR where the [Invoiced] field is True. Here is my code so far, which is returning #Error =DSum("[Value]","Jobs","[Active]=1" AND "[Invoiced]=1") It works fine for one criteria, such as...

Hey guys, I am creating an adp on sql. One of my old queries doesnt work in the new adp. The criteria is >=Date() And <=Date()+15 which finds all the jobs due within 2 weeks of todays date from our DueDate field. Anyone have any idea what the new syntax would look like?

Hey guys, Having a bit of an issue with this dsum. I used to have this code with a table that contained records for that year only. Now I am combining all years into one table. My dsum code on my form is returning a value for that month as normal but now it includes the month for every year...

I have been unable to find the answer to this question, nobody seems to know so perhaps its not possible? I switched my database over to adp format so it runs on sql, I had a parameter query that I would like to use on this new database. In regular Access, it's just [] in the criteria field to...

I have switched my db to an adp that runs on sql. In one of the queries our criteria is simply [] to generate a parameter input box. But this does not work with sql. Does anyone know the sql equivalent? I have searched the web for the past hour or so and I just cant find anything relevant...

Hi all, im looking for some advice on how to structure my db. I have a general job board that lists all of our current jobs on the go. The problem is that as we grow we want to track more and more data about individual jobs. So much data that they need tables of their own, columns and rows. Is...

Alright, still in the learning curve here, I need a hint to finish this code up. Its not changing the fields as I want it to when ok is clicked... what did I miss? Private Sub Command57_Click() On Error GoTo errorHandler MsgBox "This job will be deactivated from the Job Board, are you...

I am trying to create a simple query to view fields that start with a certain letter. For the criteria I have LIKE '[A*]' Ill give a few examples of the field data: A10-003 E10-004 T10-006 A10-005 So as you can see, the query should return everything that starts with an A, the first...

Hello all, I am trying to have a button ask for two values, and plug them both into the appropriate fields on the table. A msg box with both value boxes on it would be appropriate but so far I cant even get anything to show up. So far I have the following, I am trying my best to get this to...

Hello, I am wondering if there is anyone who can help with some vb for a command button, that when pressed will create a new table with a few pre-set columns? Also, can the new table be named after the [Job] field (4 number name) from the record in view? Please I hope someone can help! I have...

Hello again. I am wondering if it is possible to have, on our form, a button to attach pdf files to that record, and a list of files that are attached as a hyperlink to open them? Is this possible? If so, any tips on where to find some information about setting this up would be fantastic...

I have a field called duedate, this has conditional formatting to be a different color at: due in 3 weeks, due in 1 week, and overdue. We have a query to display these, so in the conditional formatting we have the following: expression is: [DaysRemaining]<8 and etc for the other dates. So can...

I have a query, let's call it "Query1". I have a split form that I would like to add a button to, that when pressed will run "Query1". The reason is only because we like to have maximum screen space (we have many columns), so we keep the tables/forms/queries box on the left minimized. I...

Hello, I was hoping to get some suggestions on how to deal with our due dates. We have over 100 active jobs (records) at any given time, each with a due date we specify in a column called... well, due date. We want a more visual way of viewing jobs that are due within, say 2 weeks. I realize...

Hey guys, I'm just writing a simple dsum, but I'm not sure how to continue. Im trying to have a text box display a sum of the field [JobValue]. But, there is a field beside that called [Invoiced] which is a "Yes/No" field. I want the new text box to display the sum of [JobValue] only for jobs...