Search results for query: *

I have queries written in access that are averaging daily, monthly, quarterly, and yearly totals. On my averages, the totals are not rounding to the nearest whole numbers. Is there a way to get the queries to round off the numbers to the nearest whole number. Thanks; bwedmund

I have a form that I use to key in information. On the form are 3 items, Location Name, Location ID, and Pump ID. Is there a way to key in information on the pump ID field; and as information changes at the location and you have to change Pump ID Field to stay current, you can have the field to...

I have a form where a date is entered every Monday. This form is used during the day all week long. Is there a way to have the form keep the "Monday" date until the next Monday. Thanks

I have a database that is used for work. I need to have my database generate a report that shows dates that are 18 months or older. thanks Barry

I have written the Visual Basic Line Below. Private Sub Percent_Of_Pumps_at__04_or_More_GotFocus() MsgBox "Please Retest. Pumps Are 80% Or More" End Sub What I would like for the line to do is -- if the Percent_of_Pumps_at__o4_or_More is 80% or more it will display...

I am using access 2000 and am trying to write a quary that will let me kmow if I have an 80 % ratio of pumps that are at -04 or lower. I can not get the program to figure this and am in need of help. The Field Names are as follows: Number of pumps (This is the number of pumps at the location)...

I have been trying to find a way to put a button at the bottom of forms and reports that will let you close them and return to a main menu screen. I am not an experienced programmer, so any help is appreciated. Thanks; Barry

How can I make a program stop and ask me to change the date that is needed?

Please tell me how I can place a statement with a yes/no statement on a form so that when a person responds "yes" the form will return to a switchboard, or if they say "no", the form remains the same. I can not remember to change dates on the form. Is there a way to make...

Please tell me how I can place a statement with a yes/no statement on a form so that when a person responds "yes" the form will return to a switchboard, or if they say "no", the form remains the same. I can not remember to change dates on the form. Is there a way to make...

<b>Please tell me how I can place a statement with a yes/no statement on a form so that if the person responds &quot;yes&quot; the form will return to a switchboard, or if they say &quot;no&quot;, the form remains the same. I can not remember to change dates on the form. Is there a way to make...

Please tell me how I can place a statement with a yes/no statement on a form so that if the person responds &quot;yes&quot; the form will return to a switchboard, or if they say &quot;no&quot;, the form remains the same. I can not remember to change dates on the form. Is there a way to make to...

Is there a way to add more than 8 items on a switchboard page. I am getting this message when I try to add more than 8 items -- Sorry, only eight items are allowed per switchboard page. Also can I exit my switchboard to windows desktop? Thanks Barry

Is there a way to add extra buttons on a switchboard and let them appear as blanks, and can you exit the switchboard and return to windows. Thanks Barry

I have an access file where I have to type in the day. A form is used to enter data. Please tell me if there is a way to type in the first or first two letters of the day on the form; and, it will automatically put the day in for me.

I have a access file where I have to type in the day. Please tell me if there is a way to type in the first or first two letters of the day and it will automatically put the day in for me.

I am using access 97 and would like to know how I can get weekly totals using a query? The program is already set up for unique, daily, monthly, quarterly, yearly. Thanks for any help