Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. diggadave

    Access Authentication

    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...
  2. diggadave

    Database Deployment

    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...
  3. diggadave

    IIF

    Hi Thanks for that, but it is still giving me a #Error instead of the result that I want! Any ideas? Digga
  4. diggadave

    IIF

    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...
  5. diggadave

    Reports with counting - brick wall.....head

    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...
  6. diggadave

    counting records

    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...
  7. diggadave

    query by month

    K, got it sorted....easier to go for the sql after all Thanks for your help
  8. diggadave

    query by month

    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...
  9. diggadave

    query by month

    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...

Part and Inventory Search

Back
Top