Recent content by BernieAnne

Just giving everyone an update. Two weeks ago Microsoft did an update to my computer, this being the first update since I bought the computer back in February. Since the update, is null now works once again just like it did for the past 20 years on my previous two computers. So obviously...

Thanks to everyone for all of your replies. Unfortunately, most of what you said was way over my head. I'm going to have to live with the fact that 'is null' and 'null' no longer works. It was much faster just going into the table at the end of the month and adding the Month and Year and the...

These video tutorials are great, Jon! I wish they had been here 14 years ago when I first started using Access.

Thanks, Doc Man. I'm not understanding why it worked on Access 97 but not on Access 2016. I've been doing this for the past 14 years without any problems.

Thanks for your reply, Ridders. I am not computer literate and it was 14 years ago since I set up my database. I'm afraid I'm not understanding your reply. In the past on the old version of Access, while in tables I would click onto a blank cell, click on filter, then click onto replace, type...

I bought a new computer with Windows 10 and updated to MS Office 2016. I was previously using Office 97/updated to Office XP. My Access database was transferred from the old to the new computer onto Access 2016. In 'Tables' when I filter to 'equals blank' and then use 'replace', the "is Null"...

Hi Everyone - I am in the process of setting up my database and thought I would be able to just pop in a CD-RW to back it up after each work day like I do for Excel. I find however, that I am not able to do so. Am I doing something wrong or can't Access be backed up on a CD? If Access can't be...

Upgraded to Access XP Hi BJackson - I just upgraded to Office XP and went back to my query and once again typed in the =round and this time it works so obviously Access 97 didn't have this feature. Thanks again for your help. I shall now continue trying to figure this programme out. This time...

When you go into properties you can set the type of number you want; General, Currency, Fixed, etc. Thanks for all your help.

I missed out the ] bracket. I had that on my query. Just one more question for you. Could this have anything to do with how I have my numbers set up? I set them as "Fixed" with "Zero" decimals. Do I need to adust this at all if I use =round?

I am using Access '97.

BJackson Thanks for you reply. I need a little more help. You'll have to forgive me, I am new to Access after having used a DOS database these past nine years so all of this is very foreign to me. I went into my query and in the two columns I went to "build" and put in the following: US...

Some, but not all, of my report totals are incorrect. They are only out by one, however it is annoying just the same and need to be correct. I know what the problem is but not how to correct it. My table and form are set up to divide gallons by .26420 to convert to litres. In "properties" I...

Pat Hartman Thank you! Thank you! Thank you! Pat you are a life saver. I never in a million years would have come up with that. As I mentioned in my earlier post I am very new to Access and this is totally different from the DOS database I have used for the past nine years. It took one weekend...

2nd Stupid SUM question Hi Everyone - I am new to Access and am in the process of putting together my first report. I am also having problems with getting the SUM of two fields. I am making the report from a Query. The two fields I am trying to add together, one comes originally from the table...