Search results

I maybe silly but still not getting it. I want to find the highest invoice no from a table called customer statements. I have a query only looking at the table customer statements and have set up the expression but it will not work. I am not sure why/ how to set up the criteria I thought...

Thanks for all the help to date. Problem trying to get a dmax field for an invoice no in a query - am doing something wrong current attempt below won't work Expr1 :dmax([Invoice no],[Table name]![Invoice no]) what am I missing - do I need something on the end when I get this to work I...

Many thnaks for this I had it set to a pop up form but the point re modal reminded me thanks again

This is I think a very simple query. with a number of forms/ queries etc open and you click on at the back it is not coming to the front for amendment. It is probably an indicator somewhere but I just can't find it any help appreciated Ta humph

Make mde file I had this problem and ran the debug - it found 2 errors in the macros. once found it converted to an MDE file no problem. assume that you have split the database prior to running the MDE

I had this problem and ran the debug - it found 2 errors in the macros. once found it converted to an MDE file no problem. assume that you have split the database prior to running the MDE.

Is it possible to use a macro in a front end to effect a back end copy of all tables (6 tables). Is it then possible when this copy back end is loaded on another machine to create something to help the user link the tables. If they overwrite the back end name I know it will continue to work...

The Int option worked perfectly - thanks again

THanks for this guys - I knew it had to be reasonably straightforward - am about to try it.

Can anyone help me to split a number using an access query to the left and right of the decimal point. I found it in a reference somewhere but have lost it. the number is generated in a query and I need to do something with the fraction Thanks