Search results

sorry i need another post to show image

image below

Hi, I have a table full of meter readings. I want to have a field called consumption which looks at the reading just entered for that month and then subtracts the previous months reading for that meter which leaves the consumption. Can I get a formula that can work this out automatically?

can anyone tell me why in my query, when i add the criteria 'is not null' some blank cells still appear. i have a table with emails in (text data type) in and whenever i run a query and add the criteria 'is not null' most of the records without an email disappear in the results but 1 or 2 still...

bump please help guys :o

ok......i might get 1 cell empty and one not so that column I wouldnt want to hide. but I would want a field to be hidden if all cells within it were blank. Is it possible in a query or not? From what you are saying I guess not. In the design of the form i changed the visible property to...

the result of the query would probably only ever be 1 record so for viewing purposes i just wanted to hide the fields that didnt have anything in them. looked at creating a form to do this and just displaying as a datasheet but still could see how i could do hide fields that had no data in them.

can you hide a field in a query if the results of that query have a field that has no data within it? its a parameter query so it could be a different field that needs to be hidden each time thanks in advance

thanks for your reply. i understand the theory of what you suggested, but unfortunately as im a novice at access I'm not entirely sure how i go about this. how do i make a reference to a record number? and how would I set up a command that made the parent field look it up. I have a...

Hi, I have a form which has a tab control on it. The form itself is just based on 1 table (tblCustomers). The tab control has 2 pages. Page 1 shows some fields from tblCustomers. Page 2 of the tab control shows 2 embdedded forms. Those forms are based on queries created from...