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

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

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

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...

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

Can you use a different querie for a text box on the same form? I want to display the (countofholes) from a querie different from the one the form uses. How can I do that? I put a new text box on the form and went through the expression builder on the data tab and picked the field from the...

How do you show the details on a line charts for each group? For each group (date) I want to show on a line chart every reading for that day not a sum. So for every change of date there could be several readings I want plotted above that day. Thanks paul CR9

I get a text field [pattern] that contains pattern sizes ex.12x12. How do I convert it to a number field for calculations? I've used the Left and Right functions to get the first 2 numbers and last 2. It will always contains two 2 digit numbers. Thanks Paul

I'm running a report that picks out one certain time that an event (evnt1) happens. Then I want to run a sub report that looks at a diffent file to pick all of the transactions that happened 30 minutes before and 30 minutes after the event (evnt1) in the main report. How do I set up the sub...

How do I count all records that have a zero value for a particular field? Thanks pt

I have a main form with options to bring up other forms with control buttons. Once a control button is pressed I need them to be closed before they can go back to the main form. Right now you are able to open a sub form and on the same screen pick off of the main form putting the opened sub...

I'm not sure how to use the dsum function. I have a form where the daily info is entered. Once the info is entered I need to display the total number of units used todate. I was told to use the dsum function. Here is my attempt, but I keep getting an error. I have the entry form in the form...

On a form all daily production stats for drilling are entered based on 20ft and 40ft drilling. After the dailys are entered I want to be able to show month to date information totals for the number of 20ft and the number of 40ft holes drilled for the month in two different display fields. I...

If have this field that shows (tons) based on other fields: =IIf([patterntype]="Production",(([spacing1]*[spacing2]*[depth])/13.5)*[totalholes],IIf([patterntype]="40' 4 Row 8x8",988*[totalholes],IIf([patterntype]="40' 4 Row 5x5",763*[totalholes],IIf([patterntype]="40' 3 Row...

I have a report that I want to show a total for the number of pounds used for particular products. I would like to show that on the report footer and not as group totals. Say if I wanted to show only the total pounds used for Product A, how would I filter for that product that with a text box...

I'm trying to show the totals for different products in the report footer in separate text boxes. Is there some type of function you can put in the running total box to only count the records for a certain product? Thanks Paul