Search results

Access 2013 I have created some graphs on my dashboard. I have parameters set: users can change the data of the graphs by selecting different parameters (fields, combo boxes, frames, etc.) There are four categories (series): In Renovation, Occupied, Out of Service, and Ready to Rent. Each...

The Graph in Access is NOT the same as Excel - at least 2013 isn't. It is limited in what it can do compared to Excel. I researched via Microsoft's website and it seems to be everyone's frustration. Microsoft's answer is the capability of linking Access with Excel and visa versa. I really hope...

It doesn't show LOTS of things - but a few... -how to access your data while in the Graph software (not by datasheet) -how to make a particular series into a line instead of a column (like it does in Excel) -how to make it show just the value 'as is' instead of using a function (sum, avg...

Using Access 2013 Trying to create a chart in Access on a form. My first question, how do I access the data while in the chart software? I know I can use the properties to get to the query, but double-click in chart, and I cannot locate the data series to manipulate. Second question: how...

PLOG - thank you so much! You are the best - it works like a charm!! Have a great day!

Here is an example. Black Fields are within the tables given. Red Fields are what I am trying to accomplish. I hope this helps - thank you! So basically - I need to know For each unit (group) how many days it was that in that particular status, and how many days since last status change...

I have multiple tables: tblRegion - RegionID, Region tblProperty - PropertyID, Property, RegID(foreignkey) tblAddress - AddID, Address, PropID(FK) tblUnits - UnitID, Unit, ADDID(FK) tblStatus - StatusID, Status, StatusDate, UnitID(FK) I need to group and find date difference for each...

Hello, I am using Access 2013. I am trying to create a query that will count the days difference between two dates. The dates are in the same field. I want to group by Region. So: tblRegion = RegionID tblStatus = StatusDate I know how to use the DateDiff when it is two different...