Search results

Hope someone can help me with this question. Should be easy for someone with good experience. I have a report that i use the following equation with. =IIf([Sum Of Sum Of Pound Conversion]>=10000,"Hazardous Substance > 10,000 lbs",null) If the value exceeds 10000 i want the specific cell to...

Thanks, I am using 2007. But since you answered I was wondering if you could help me with another issue I have a report that i use the following equation with. =IIf([Sum Of Sum Of Pound Conversion]>=10000,"Hazardous Substance > 10,000 lbs","") If the value exceed 10000 i want the specific...

Helllo, I would like to know how to make a database so that any individual can go into the database and enter information into a form, but they would not have access to the internal workings of the forms, tables, queries and reports that I have built. I guess i could have a password that would...

Yo man you are awsome. Thanks for the help I really appreciated it. I was stuck for a while. Thank you very much it worked. Any ideas of what i could purchase to get better at the expressions/sytax/code. KEvin

My goal is to have a report show the beginning and end date of each quarter that a specified sampling dates lands in. For example I do water sampling monthly and my query takes the avg and max of some characteristics of those samples. I need the report to show the begginning and end of each...

can you screen shot what you did so i can copy it? kevin.platt@ngc.com. Thanks

Thanks for getting back to me. I tried what you suggested and cant seem to get it to work. Here is my scenario In one query i have below in one collumn Quarter: DatePart("q",[SDate]) Then I try to use this in another collumn IIf([Quarter]=1,"01 01",[Quarter]) So basically what i want is...

Hello, I was wondering if it is possible to pull a query from an expression already in the same query. (or even in a different query) I dont know the formating to do this. Thanks

Bob, can you tell me how to make this happen on a report. I put all the syntax tent that you gave me and put it into a module, but I do not know how to pull the module information into a report. I woul assume using a macro, but I basically do not know what to put into the report cell to make the...

Bob, this gets me the st and end date for a month when i put it in a report cell...=DateSerial(Year([SDate]),Month([SDate]),1) Can I do the same with quarter in the name to get the st and end dates for a quarter that the SDate lands in?

But can you get the start date and end date of a quarter? Can you show me how it would look in the text box with the formating mm dd yy. Sorry for so many questions but this is a great help.

Thanks you're awesome. Can you do that with quarters also? Also I need to format the date at as 04 16 09. Would you know how to put it in that format? The reason is because I am putting the data into an already formed report template (basically an image that I pasted to the report) Thanks Kevin

Thanks bob, but what if the date is for example 04/16/09 and not the current date. The control source that would be affected is "SDate". Can you put that in an equation and get results as the start of april and end of april? Thanks

The reason is probably because a number divided by zero is undefined. does it show up in the table as Num# also? It sounds like you could make an expression to put in that control source that would show blank or zero when it comes back Num#. Let me know if you are interested and I can try to...

Can someone help me with this Access/Visual basics question. I need syntax that will allow me to show the start date of each month and the last day of each month that a particular date falls into. For example if my record date was in 04/16/09, I need the month start date and month end date to...