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...
Don't really want to use sql statement.
Was just looking to use the query builder in access, where I set the criteria on the date column equal to a number for example 6 (for June)
But, I need somehow to tell access to display only those dates where the month is equal to 6....how?
Best Wishes...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.