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

    Multiple counts per date

    The report works well, when I want to display all records, however when I want to select a date range problems occur. In the Crosstab query I input the following into the criteria in the date field >=[Enter Start Date? DD/MM/YYYY] And <=[Enter End Date DD/MM/YYYY] I also defined the...
  2. Daps89

    Multiple counts per date

    The missing "DateValue" appeared to be the problem. I now have enough information to work on the report. Thank you for the help
  3. Daps89

    Multiple counts per date

    That almost gives me the perfect result, thank you for all your help. One problem that it creates, is that the values of the counts are displayed on different lines. For example if Type A is selected in 2 separate records, rather than the query displaying: Type A 17/03/2011 2...
  4. Daps89

    Multiple counts per date

    The joins on the tables may not have been correct, however I have put all of the data into the same table, in hope that the issue can be resolved quicker and to simplify the query. Now all the data is stored in tblVesselID, which contains the fields VesselID, TodayDate, Logged, VesselType...
  5. Daps89

    Multiple counts per date

    tblVessel contains the the details about the vessels, however tblVesselType and tblIncidentIniciator are tables that link to the table and are accessed through combo boxes. tblIncidentIniciator contains An ID and the field LoggedBy, which contains the records "a", "b" or "c" tblVesseltype...
  6. Daps89

    Multiple counts per date

    I am not having much luck with the suggested union Query and when using the code I am prompted to enter parameter values for vesseltype and logged by. I have no idea why that is happening but any suggestions would be much appreciated
  7. Daps89

    Multiple counts per date

    The below code gives the error "is not a valid name name SELECT TodayDate, VesselType as ColHead FROM [tblVessel] WHERE [tblVesselType.TypeOfVessel="Type1" Or tblVesselType.TypeOfVessel="Type2" Or tblVesselType.TypeOfVessel="Type3"] UNION ALL SELECT TodayDate, Logged FROM [tblVessel] WHERE...
  8. Daps89

    Multiple counts per date

    I hadn't thought of that, but after a quick it seems I can only do counts as if the two different criteria are linked. Rather than each criteria being a sub-criteria, I want them all along the top of the report as separate items. Does that make sense and can that be done using the pivot table?
  9. Daps89

    Multiple counts per date

    I need to create a report that displays multiple counts so the end result looks something like: Date Type1 Type 2 Type3 A B ........ 17/3 1 3 2 2 4 18/3 2 1 5 5 6 The data comes from tblVesselType and Type1,Type2,Type3,Type4are in one...
  10. Daps89

    Clock in/ Clock out

    thread702-1579349 Hi, I want to create a form in Access, where it is possible to clock in and clock out. The form will contain the fields FirstName, LastName, PurposeOfVisit and the clock in and out fields will be hidden. The purpose of the form is to log who visited a particular site and...

Part and Inventory Search

Back
Top