Search results

Try again with the file although I have also sent it by e-mail as suggested. C

Here is the file - any help to make my life easier would be greatly appreciated.

Fornatian, how do I post a copy of the table structures- I don't understand what u mean. I do have a book but no time to read it - spend all my spare time experimenting with the pc and having to reinstall!!!!!!!!!!!!!!!!!!:confused: :rolleyes:

Thanks for your reply, The tables consist of different customers buying 4 different services, but we get them from the same supplier so the info needs to be kept separate to make things easier for us to control them. If there is an easier way to do things I would like to know - all my...

Hi, Is there anyway I can programme keys to repeat actions in the next record - eg date and in the next record underneath pressing for example F8 the date repeats. I know by pressing ctr ' this does it, but want to be able to repeat actions pressing only 1 key instead of 2. Would one use...

I have 4 tables all with a primery key which is the reference number and to distinguish between them I have also given each table an ID (A, B, C, and D). What I want to know is if there is any possibility of combining the ref number with the ID on a form thus making a number, for example 63B...

:D :D SUCCESS!!!!!!! I have sussed out the problem at long last. It was all to do with the field MATTOTAL - I had put MATTOTAL in the table but with no values and so it could not do any calcualtion in the query. I now have put a field TOTAL into the query which doesn't relate to anything...

Hi RV comes up: Syntax error en query expression nz([matent],0) etc etc -quoting all the changes I have made. catlady

SELECT [MAT Cobros].NOMBRE, [MAT Cobros].[Nº PAX], [MAT Cobros].CUIDAD, [MAT Cobros].ENTRADA, [MAT Cobros].MATENT, [MAT Cobros].SALIDA, [MAT Cobros].MATSAL, [MAT Cobros].MATTOTAL FROM [MAT Cobros]; Is this what you mean?

So simple - all those hrs of trying for nothing - hope myother query turns out to have an easy solution. Thanks a lot. Catlady:D

How do I do that?

Hi there - can anyone help pls. I use the reports to print off bookings which sometimes are several pages long. The heading needs to go on every page - but here is where I am having problems - my report heading is also the page heading and so I am trying to suss out a way to get rid of the...

Hi again - still no luck, no matter what combination I put in I keep getting the warning messages that it is not right. What is QBE - I assume that it was design view - expression building. Can calculations be put into all types of queries? - Maybe there is something wrong with the query...

Hi again - still not having any luck. I keep getting things like the following - "Expression contains invalid syntax" "You omitted an operand or operator, you entered an invalid character or comma,or you entered text without surrounding it in quote marks. I have tried all ways. I have taken...

Thanks for your replies, but I'm not sure if I am just being really thick or what but am having no joy. The fields I am working with are currency and I have tried = nz(MAT ENTR)+nz(MAT SAL) , nz([mat entr],0)+nz([mat sal],0) = mat total, with and without inverted commas around the 0 and god...

:confused: can anyone pls help - I am trying to write a criteria expression in a query to add together the values of 2 fields giving the total in another one. I have been reading up on Nz and IIf, etc and have tried loads of different things but only end up with 0s or being told the expression...