Search results

Actually, you've helped me much more than you could guess. You've made me tackle the problem by mixing in ye olde Expression Builder and the result is a far less complicated product. (I usually try to avoid building that way. In this case, it's made a great job.) So the cry still is MoP (aka...

Unfortunately, I can't. Ah well, thanks for the guidance.

Sorry, but it brings out the old error warning about invalid syntax and enclosing text data in quotes. ??

Hi MoP er SJ I must be putting it in in the wrong place. This is where the percentage begins, in a query PerCent: ([qryInWorkTotal].[CountOfName])/([qryWorkPotential].[Potential])*100 & ' %' Trying yours in the form properties and query properties makes no change, unfortunately. (I still have...

A field arrives at a percentage and feeds a form. I want it to have one decimal place. The form’s Properties, “Decimal Places” lets me choose decimal places, but “Format” remains empty, thus offering no formatting choices. Can anyone help please? Frustrated of Warwickshire

Like this start on a new line, Rich. I'll borrow that if I may. Cheers =[SomeNAME] & Chr(13) & Chr(10) & [ADDRESS]& Chr(13) & Chr(10)&[PHONE]). ;)

Yes, I did that, thanks, and the links to those tables look good. Those tables provide the look-ups for things like work and race and each has lots of entries. What I want to have is a table with each employee's personal details, and one with his working details and another if he wants to go...

Thanks, Dave. Yes, I got through the first part ok, thanks to your guidance. That plan is to split the database into three tables instead of the solitary main table. With your help, I have impressive one to many links with the look-up tables. I want to link these three tables together, but at...

Many thanks. Looks simple put like that. I'll be referring to this advice often. Very grateful.

Thanks very much, Dave. There are 24 lookup options. Would you do that one at a time?

Lobo You're a star. Thank you very much. Works very well. I don't have left joins/right joins et al at all clearly in my mind. Is there a simple rule about which decides which, please?

Thanks, Wayne. I'm treading unfamiliar territory here. The story so far ... An important database has one main table - tblOriginal. It works ok but it doesn't follow the relational idea. I have a few days when the database isn't in use. I thought I would try to split it up into...

I want to change a table that had two or three combo box choices to look-up lists. But it will mean that the fields that were completed become vacant - and it looks a massive job to input all that information. Be good to code all that's in the fields 'Work' and 'Race' and 'Something' from...

Thanks, Lobodava, I will give it a try tonight.

Two tables – tblOne and tblTwo have identical fields. tblOne has fuller records than tblTwo. I want to say in sql (MySql to be specific) INSERT INTO tblTwo (Address, City, etc) SELECT Address, City, etc FROM tblOne WHERE tblTwo.Sname = tblOne.Sname; WHERE-wise, this isn’t the way, I now...

It does. You're brilliant. Many thanks.

Hi MoP I do, but it opens the form in normal view. (access2k)

I want to open a form which is in data view. So DoCmd won't oblige with my usual form-opening code, and it isn't interested in my amateurish playing with options. Anyone know the precise cmd code please to open in data view?

Thank you, Experts. Tools/References/Remove DAO | close down | restart | Click DAO. All's well that ends well, and it is. Much obliged for the advice, somewhat abbreviated though it was. Handy link, thanks Rich. I'm told that the fault very often/almost always lies with DAO. And it did. Cheers

ecniv, thanks, but it isn't the sql which has been in use every day since Noah.