Search results

The sum function in datasheet view is only visible in datasheet view. You need to do your summing in the report itself. Reports are very good at summing by group or over the whole report. Here's a reasonable explanation: https://www.techonthenet.com/access/reports/group_footer1.php

myTime: TimeSerial(Int([myValue]),([myValue]-Int([myValue]))*60,0)

I can't think why you would pay any money for an "Excel 2016 For Complete Beginners" type course. There is so much good free material easily available online. Of course there can be a world of difference between a good tutorial and a bad one - particularly for a complete computing novice who...

Just go to www.wordpress.com and click on the "create blog" option. I have not done it for a while but it will hold you hand from there. Don't worry too much when choosing from the various themes and options - as I remember you can tailor everything later. I look forward to seeing your site...

For hosting on your own computer you could start here: http://www.howtogeek.com/177129/beginner-geek-how-to-host-your-own-website-on-windows-wamp/ For hosted service, you just need to find a hosting service that covers the basics. I only have knowledge of my own service here...

Maybe do it the other way round. Create a calculated field in your query that calculated the year they would need to enter e.g. EntryYr: FY_Year - 1. The you can just do the [?] in this calc field.

Your query should look like this: SELECT table1.ID, table1.student, table1.mark, table1.Subject, Table2.Grade FROM table1, Table2 WHERE table1.mark Between [table2].[min] And [table2].[max]; Note how there is no join in the query. This is called a Cartesian Product and the criteria ensures...

Example of calendar approach attached. The calendar takes only a few minutes to create in Excel (and then copy/paste) and is a one-off exercise.

I would strongly advised against this approach. Hard coding business rules like this is not good design. For one thing, the OP says the rule applies "for most months". Also, given the OPs example I can't see a rule as such. The first period of 2016 seems to start on a Wednesday. But more...

Don't use a start and end date in your calendar table. Just use a single date field and enter all dates for your calendar. This becomes an easy to implement join. Also, it means you can time slices for any date e.g. quarter. Make sure you don't name any date fields "Date" as this is a reserved...

I've certainly added extra columns to sharepoint lists in a live environment without any issues. When you do this if you are using an Access front end you will need to refresh the sharepoint schema on each user - can't remember the option but right-click on the relevant table links in Access and...

like gasman said, the code I wrote was the wrong way round. Just reverse the references either side of the equals sign.

Then I would suggest that type and category aren't really related directly. They are really related through transaction. It's the transaction that gives them some relationship. The reason I question is because it is unusual to see a circular relationship like this.

Looking at this I actually think you need category in the type table i.e. a category has many types. Is that right? At the moment you have one type has many categories.

In your relationship view you should not relate tblTransactions to tblTransactionCategories. The two tables are already related via tblTransactionTypes. You also need to remove TransactionCategory from tblTransactions as this should be determined from the other relationships. The reason is...

Create a continuous form with the fields that need to be entered into the table. In the header, create text boxes to the fields you want to repeat. Then for the BEFORE INSERT event for the detail section, use the following code Me.TransactionDate = Me.txtTransactionDate...

Empty records DO have meaning in the sense of a set of records. If 14 out of 1000 records are blank, that could easily have some meaning. If you delete the 14 blank records then you have lost that information.

Here's a useful reference: http://access.mvps.org/access/forms/frm0031.htm So in your case I think you just need: Forms![Carriers Main Form]!Address1 = Forms![Carriers Main Form]![Carrier Personnel].Form!Address1 There is not need to use a temporary variable. hth

The logic you have provided in the first post implies to me that you want to set all the fields in a row to null except if any one of the fields has a value of "CT". Put another way, if any one of the value in a row is "CT", do nothing, otherwise set all values in the row to null. The SQL...

I think this has now been cross posted here.