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!

Register Log in
  • Congratulations Chriss Miller 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. littleboots

    Windows 98 and Access 2000 Report

    Hi I have a basic report & query which I've set up in Access 2000 on a Windows 2000 PC. When collegaues try to run the report on their PCs, on Access 2000 and Windows 98, they get the following error: "Undefined Function 'Left' in expression". I ahve checked that the query works OK...
  2. littleboots

    Count results - ignore duplicates

    I need to count the number of double beds required on a report. Currently the report is sorted by room number and then shows the people who are occupying the cabin (either 1 passenger or 2 passengers). If I do a Count by either CABIN or by BKRF (booking reference), =COUNT([BKRF]), then it counts...
  3. littleboots

    Count records in a report using criteria

    I need to be able to show total numbers of bookings of twin and single rooms in a report. The rooms have different codes in the field [PKGE], so providing a list of people is no problem (sort by PKGE to get twins first, then singles). How do I count the number of twin rooms? If I do =count(*) in...
  4. littleboots

    Wordart.... in a Textbox?

    My Dad is new to computers and completed one of the free introduction course recently... he says he was shown how to put Wordart into a Textbox, now 6 months on, cannot remember how. I've tried inserting Wordart into a Textbox and into a Table, without success - it automatically is positioned in...
  5. littleboots

    From a form launch Excel and chosen file

    I've designed a form with buttons that link to my reports in a dbase. I need to also add buttons that link to files in Excel. I have discovered how to launch Excel via a button on a form, but I can't get it to open a particular file at the same time. I've tried doing it through Visual Basic but...
  6. littleboots

    Count criteria in a column on an Access Report

    I am new to MS Access and I'm having a problem summarising data in one of my reports. The data I have is linked to a Flight Information query which gives Surname, First Name Title etc and the Sex then Class eg Business, First or Economy I have managed to count the number of passengers using the...

Part and Inventory Search

Back
Top