Search results for query: *

I want to set up a report to run from the first date of the month to the day before the current date. What is the formula that represents the first day of the current month? Thanks pt Cr9

I want to run a report that captures data with a date range of today's date from the same day but a year ago. I guess I'm looking for a rotating year each time the report is ran. What is the best way to accomplish this??? Thanks Paul CR9

Worked great! Thank You pt

I want a field to default to the 1st day of the current year. What is the date function for that? Thanks pt

Bob That changese the color, but I want to change the highlight color. DO you know how I would code that? Thanks pt

I need to write a formula with if statements. I need this highlighted different colors and the format wants numbers only. If left({equipnum},2)="MD" and {duration}>"00:02:00" then highlight yellow {equipment} else if left({equipnum},2)="MA" and {duration}>"00:04:00" then highlight red...

I have a couple of things I need to highlight based on a couple of criterias. What is the word you use to highlight a field? Say, if I wanted it to be highlighted yellow. Thanks pt

PERFECT, thank you so much! pt

I want to list only the rtrim[operid] that contain a 5 digit string. I used operid like '_____' and it list all 5 digit operids, but it also list 4 digit ones. select distinct rtrim(OperId)as OPID , rtrim(OperName) as OP from vWorkers where OperName is not null and OperId like '____' order...

I have a year to date report that is grouped monthly. For each month I want to know how many days have total units sold over 1000. How would I use the count finction to do this in a text box? Thanks pt

Is it possible to use a date range as a subreport link?? In my main report I have a field that totals fuel usaged for individual trucks then it goes to a subreport linked by truck. I need it to use the same date range as the main report uses. Thanks pt CR.9

Is there a way to convert datetime fields to just date fields. I use a datetime parameter and in my database for some reason they use a datetime field that never changes from 12:00:00AM. When you use the parameter for a search unless you put the 12:00:00AM it misses the dates you want. This...

worked perfect!!! Thanks pt

I've never done an update before! If have table 'SurveyPoints' and want to update the field [elevation] that contain nulls with zero. How would I write that statement? Thanks pt

Where and how do you do the update code? Thanks pt

I added a number field to a record , but it shows blanks in the table for the old records. Is there a way to convert all of those blank fields to show 0 without putting a zero in each field by hand? Thanks pt

I copied your statement and it brought up the same number mine did. I used the expression builder and picked the textbox for the calculation and I still got the #Name? error. Am I doing something else wrong? Thanks Paul

...fine, but when I use it in another textbox "calc" for a calculation it gives a #Name? error. "totlbs1" =DLookUp("SumOflbs1","Blast Product","[shotid]=[Forms]![NewMain]![shotid] and [pattype]=[Forms]![NewMain]![pattype]") "calc" =[totlbs1]*1.34 DO I need to do something different??? Thanks...

That worked great, but once you get it how do you reference that text box value to use it is calculations? Thanks paul

Remou Can you have multiple criteria on Dcount? If so how do you do that? thanks paul