Search results for query: *

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

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

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

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

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

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

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

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?

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

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