Search results

Have you tried NZ(YourExpression) or nz the different parts of your expression?~)

Datediff is not reliably when calculating age, so I've made an example... Feel free to use it!~)

In all your forms enter this criteria in the query: Forms!frm_Main_Form![cbo_AgentName]

You are doing the right thing you just need to make the join between the customer table and the invoice table into an outer join. You do this by right clicking on the join and choose to get all data from the customer table!~)

Always nice with a welcome!~)

Hi Steven got your call for help.. got here a bit late... but can confirm that Paul's solution works!~)

I don't want to get in the middle of a financial transaction!~)

Please send material and I will give a clear offer!~)

you can also create a couple of queries: Query1: SELECT TableName.Colour, Min(TableName.Rate) AS MinOfRate FROM TableName GROUP BY TableName.Colour; Query2: DELETE TableName.*, Query1.Colour, Query1.MinOfRate FROM TableName LEFT JOIN Query1 ON (TableName.Rate = Query1.MinOfRate) AND...

..by the way finish of by creating a new blank form, go to design mode and put some buttons on to open the different forms, reports and one to quit access. It's all step by step wizards. Then go into property for the form and set record selectors and navigation buttons to No. Then save the...

sounds good... and yes you are correct it counts the numbers of visits because if you bring in the log numbers then it will be the same as the other report..

go to properties\recordsource on the report and click on the little button with the 3 dots..

..a quick run through the report, had to make time into minutes... you can do your thing in the totaltime, so you get hours and minutes or use the example I mentioned in an earlier reply!~)

I will build it for you and make the user interface simple. Please send additional info to .. thanks got it...

Hi, I'm on a 2007 machine, so I'll have a look tomorrow... Why they made 2 versions of accdb files is beyond my grasp!~)

1) make a group with person and select footer then put a sum field on the footer.. 2) you have to look at the recordsource, you can change from showing property sheet to showing add existing fields. When you have cleaned up the parameter issue will disappear.

if you get two rows that are different then you have to look at removing some group bys..

select distinct

I recall a small db I made about minutes and short time you can see if that gives you any inspiration http://www.parodux.com/wp-content/uploads/2010/01/MinutesIntoTime.mdb

The parameters and question 1 are solved by right clicking an select sorting and grouping. It will show 'expression' in group by and in sort by, change that in the dropdown. 2) When you look at the grouping you can add a footer and a sum field here will give you subtotals. 3) Yes, in teory...