Search results for query: *

Hi Any help will be more than appreciated!!! I am trying to set up a database, which will allow me to have a number of login usernames and password, with different security levels. This database will then be run on a number of different machines and networks so I cannot use Windows...

Hi I am working on a database, which I will need to deploy in a number of offices. Each record entered into the table will need to include the office ref no. What I would like, access to display a form when first used to select the office ref no, and for access to remember it and enter it...

Hi I have a report which will display a count of field. If it is zero, the report field is displayed as blank. What I want is, if the query count is null, I want a zero to be displayed. I thought that it wouls simply be a case of:- =IIf([CountOfItem]>0,[CountOfItem],"0") If...

Hello I've tried and tried to get this to work, but to no avail. I am working on a database for an information centre who offer information to young people, based around 10 headings. What I have is a table, which contains the following field names:- infoid (autonumber) infodate...

Hi Guys I am trying to produce a report on a query, which will count the records the query holds. I know that I can get the total by using =Count("*"). What I would like to also do, is get a count of each of the record types. Record types range from numbers 1 to 10, and i would...

Hi Guys I have a date field in one of my tables, and I would like to run a query on it where the month will be selected in a form, and data returned only for that month. I have been looking at the query builder screens, and noticed there is a built in month function, however I am not too sure...