Hello,
I have a querie that calculates the average of two sets of times taken from a calculated figure in a table.
My problem is that the returned value seen when the querie is ran needs to be of a clock format. Eg 0.75 needs to read as 0:45
I have attached a Database to help, as i am unable to do this.
Any suggestions given i am greatful for.
I have a pivot chart that has site locations, and hours on the bottom, and then count of records with each site. Which is how many people used this site during this time for each bar. My problem is when I generate my pivot chart, every single time I have to fix the scale on the right hand side because it has decimal points in it. They only appear when I add dates/times to it.I want to give this to my boss that has access runtime, so all he has to do is click the button to get the chart and then print or send it off. How do I get rid of those decimal points when the report is generated?
View 1 Replies View RelatedI'm trying to get this query to work:
Code:
SELECT Avg(Round([Final 205].[LastOfSumOfRehLOS],2)) AS AvgInpLOS, Avg(Round([LastOfSumOfWaitLOS],1)) AS AvgWaitTime, Count([Final 205].PHN) AS Observations, [Final 205].LastOfIntensity AS Intensity_Level
FROM [Final 205]
GROUP BY [Final 205].LastOfIntensity;
It doesn't found the result to two decimal places.
Hi there,
I am not sure the best way to do this,
I have a field with values that look like: 1.69553366385509 or 0.0061705541157596
I want these values to look like: 1.6955 or 0.0062 (4 decimal places [rounded up if possible])
Thanks for your help with this
Sue
Hi guys!!!!
I try to find an answer in the forum about "Average Fields",but ican't
I am confused:(
I wan't to export Avg Of the fields like in the panel below:
Whenever I use a look up field to enter values, I get the ID number displayed instead of the value (name). How do I rectify this error.
View 2 Replies View RelatedHi,
I have a order system which allows customers to place items on. When an item is selected and a quantity has been entered and add button is selected, this adds the item into a listbox with all the details.
Each item that is selected a quantity is selected, this would then work out a total price and this total would be displayd within the list box too.
i want to add all the totals up for that order and have it displayed within a text box.
for example:
product ID, Name, quantiy, item price, totalcost
P0001 Top 5 1.00 5.00
P0002 Top 4 2.00 8.00
P0003 Top 3 1.00 3.00
i then have a text box where i want to display the overall total for these items within. hope this helps. im really stuck on this one!!!
I'm sure this is simple and I'm just missing something...
I have a combo with two columns and the row source set up as a query which returns two columns.
When I click the drop-down arrow for the combo box, I get exactly what I expect.
What I want to do is initialize the combo box so that the "default" selection is displayed in the "text" or "value" section of the box. I also want to be able to update this when the user makes a selection.
I have no problems when using a list box with something like:
listbox.value = <Some Index in the listbox>
With the combo box, I've tried:
combobox.text = xxx
combobox.value = xxx
combobox.column = xxx
combobox.itemdata = xxx
combobox.listindex = xxx
The value property sort of works -- It displays the data from the first column right justified in the "text" section of the combo box. I need to have both columns displayed the way they are when the combobox is dropped down.
Any thoughts?
Thanks in advance...
Hi,
I am trying to choose an entry from a COmbo Box which ahas a Lookuop underlying in it. I then want to display the additonal four entries in the form it self. The data is already created and displayed in a query. The primary key gets displayed but thte other data cannot be displayed. Is there any way I can display the other details eg: Firstname, Surname Age in the same form but under different fieldnames. I am not sure how to do this.
I could retype it all in but that is uneconomical. Any ideas? Please help.
Thanks.
New to Access - I have a database which currently has 200 records. When I run a query or report it's the 150th Record which comes up first. I do get all the information but would like to know how I set it up that it's the 1st record which is taken first and then so on.....
View 1 Replies View RelatedWhen I view data in linked tables in MS Access containing foreign characters (umlauts, accents, etc), the foreign characters are not being displayed properly. It is not a font or Access setting because I am using a separate similar database (also containing linked tables) where the foreign characters are being properly displayed.
Is there a setting I'm missing in the linking of the tables? Not sure where else to check.
I have successfully used an Expr code in my query to get the calculated result that I need. My problem is I can't seem to display the results on a form. I get the error "Name?"
When I try to find the query on data control which I used, it does nothing but shows me the fields from my table. How can I get a query expr column to display in my form?
the name of the query is "together" and the column's name is "everyone"
Can someone please point me in the right direction
i want to make it equal to my forms adjusted width but i don't know how to do that. Also i thought it would look like a form enwrapped within a rectangle or a square yet its gluded onto Access with no border
View 2 Replies View RelatedI have two tables, [ATWelding] and [Results] . They are linked as they both have Weld ID.I want query to show any ATWeld ID that doesnt match a Weld ID in [Results].I can't use SQL as my database is on the web compatible platform. I attempted to do this using InStr([Results]![Weld ID]) in my Weld ID ATWelding criteria on a query but as I am using the web version an error message saying the expression is not compatible with the web is being displayed. I can run the query in my web database?
View 2 Replies View RelatedI have a query that finds an average. How can I get the average to only show two numbers after the decimal?
View 4 Replies View RelatedI apologise for my ignorance, but I’m very new to Access.
I have a database of dates, that I need to analyse.
I have created a Form called "DateRange" with 2 date fields;
Text1 = Date From
Text2 = Date to
Command1 = Preview Report
My Query has 2 fields;
Slotdate = all the dates (show as 20051210)
Actdur = Actual Duration (show as numbers 1 or 12 or -3 etc)
The SQL View is;
SELECT slotapp.slotdate, slotapp.actdur
FROM slotapp
WHERE (((slotapp.slotdate) Between [Forms]![DateRange]![Text1] And [Forms]![DateRange]![Text2]));
I just want to calculate an average of Actual Duration
So that my report displays the average duration between the date ranges.
Any assistance in this matter would be greatly appreciated
I've looked thru a lot of posts, but can't seem to find the solution. It seems like this should be something I could figure out, but so far have not.
I have a table that is showing a production number for each day. What I'm trying to show is the best 5 day average production over a period of time.
Thanks,
Tom
Could someone please tell me how to work out the age of someone using a query or report and the average age of everyone?? I also need to know how to put on a report the total number of people satisfying the search criteria. It also says i must obtain a single record for each person and to do this i need to change a query property to allow only unique records to be displayed? do u know what this property is??
Please help!!
Thank You
Hello,
I'm trying to limit the number of text characters displayed in various fields on a form. I want it to appear so that after a certain number of characters it then displayed "..." indicating there is now information in a field.
Thanks for any help!
Hi I'm a teacher and have to set targets for classes, I have created a database which allows me to input targets for the classes. I now need to then display the class target for individual pupils in a new layout. I am sure there is an easy solution and I am looking at the problem from the wrong direction. Thank you for any help
graham
I have a query that looks through a table and shows me any calls that have a status of either 'O' 'or 'C'. What I would like to have in the query result is the O or C replaced with the words Open or Closed. Then when my count will make alot more sense rather than having O 29 etc.
I have had a look through the forums on the net and I am convinced this question has been asked before, but I am struggling to find the key word to search for
Kindest Regards
I have a continuous form based on a query with the criteria as all records where a certain field is null. From this form, the user can fill in values for the null field. I then want to click a button on the first form to open another continuous form showing the same records so the user can go on to do something else. The problem I have though, is that if I base the second form on the same query as the first form, any records where the user has filled in a value for the previously empty field will now not be included in the query results. Is there a simple way of doing this?
View 2 Replies View RelatedHello again my forum o' saviours, Current filter: WHERE (Assignments.[AcademicYear]) Like ([Please Enter Academic Year])AcademicYear is a field in the Assignments table (duh). In this same query, I have a couple fields (equations and if/thens built on the assignments table) that will need to be used as further filters. I thought something like WHERE ((Assignments.[AcademicYear]) Like ([Please Enter Academic Year]) )& (len([groupwinterbox])+len([groupspringbox])+len([groupfallbox]) > 3) would work, but I keep getting pop-ups asking what the values of the three query-based calculations are. Where did this noob screw up?
View 9 Replies View RelatedSome of my collegues have been experiencing this problem with a very simple database i knocked up for them. First off some background. I have a main form (frmproperty) with 3 subforms linked to it(frmroomdata, frmlocation and frmsample). by a property code. Two of these subforms are linked (frmlocation and frmsample) these are linked by location code which is an autonumber.
These are laid out so that you fill in room data first, then location data then finally sample data. However after the location data has been filled out and a user attempts to move to the first combobox on the sample subform a message pops up saying that another user has altered the database and would you like to save changes (Impossible as they are using the database on a local drive). After this happens they reopen the form and in all the frmsample fields is "#deleted"
This doesn't happen every time...infact over the last 2 days i have been entering data myself to try and get this error with no luck. Has anyone else come across this and know how to fix it?
Thanks in advance
Matt Collins
Hello,
I'm new at this, but here goes. I have a memobox on a form that I set the DefaultValue to display instructions for what to enter in the memobox. I would like these instructions to be visible until the user clicks or tabs into the box. Then I would like these instructions to disappear when the user begins to type something in. I've tried using several different event scenarios, but none does exactly what I want. I don't want to use a control tip as it won't appear until the user actually enters the memobox and I want the instructions to be visible before that time. However, this is what I've done at this point because I haven't been able to fiqure out how else to do what I want to do.
Any help would be appreciated; I'm sure this is something very simple for all of you, but I've spent several hours trying to work my way through this.
Thanks, Charlotte
P.S. I've read many of the posts, and have gathered many helpful tips on a variety of Access topics. Thanks to all of you out there!
So...I have a table with 2 fields: Name and Times Accessed
I have three names in the table: Shane, Bill, Chris
There are multiple entries for each name with no primary key set.
The Times accessed are as follows:
Shane 2
Bill 2
Chris 1
Bill 3
Shane 5
This is what I want to do if possible:
I will have multiple text boxes on the form that will display running totals for different people in a table.
So i have three text boxes on the form. 1 for each name. i want that textbox that corresponds to each name to keep the running total for Times accessed. So, for Shane it would be 7, bill would be 5, and chris would be 1.
How/where do I do this? need more info?
Thanks...
Shane