Search results

JHB, If your still following this thread. I was able to integrate your bar chart report into my database. I thought that I would be able to just create a query to select a date range so I created another bar chart report using your design but substituting the query for the table. The report for...

This is fantastic it is just what I have been looking to do.

I will make some questions come up in the query that will grab the data from specific teams and narrow down the date of the data to be displayed. I don't need help with that part. I am attaching a EXCEL file to show what I want the data to look like. I still have to insert the target that the...

Hello, I am trying to bar chart information that I create in a report that groups information based on Teams and hour meters that are grouped in a report. is it even possible? I am attaching the ACCESS DB.

ok, I figured out a way to do it just in the report. Thank you for your help.

Managers of the department want to check how teams are using the equipment(Over 300 Pieces) and have a Individual periodically checking the hours used, randomly, they want me to give them reports monthly to show them how much the equipment is being used. Also to bar chart the information to...

First Field "ReadingDate", Second Field "MeterReading" the Table is "HourMeterTable" I am doing this in a query. I want to enter dates to search by.

So Mark, Would it look like this? FirstRead: DLookUp("[MeterReading]","HourMeterTable","MeterID = " & [MeterReading] & " AND DateRead = " & [ReadingDate] From) I am getting "The Expression you entered contains invalid syntax":(

Hello all, I have this database that has information taken from equipment that has hour meters. My data fields have the day the equipment hours were taken the serial number of the equipment and the meter reading. what I need is a report that gives the total of hours run for any given month. I...

I figured it out it has nothing to do with the date in my query another part of the date base did not get updated with 2012 charge rates so when the query ran there was no data because of the missing rate. thanks for even replying to my question

Sorry date/time

The data type is "date". This query works fine as long as the date is before the year 2012.

Help, I have a query that will give me records between dates as long as the dates I put in are before the year 2012. When a put in date that are from the start of this year the query gives me no records. yes there are records that contain the year 2012. Has anyone else had this problem...

I have it built using combo boxes and input from the combo boxes fill a between statement in a query to get the records so I have added another combo box for a location that also is in the same query to get records based on location but when there is nothing in the date combo's I don't get any...

Bob, If you are still watching this thread I have another question. I want to add another selection to the drop downs one that will specify a location that will sometimes use the date selection and other times not use the date selections (meaning that the dates would be blank) so I would get...

Ok I figured out that I had spelled one of the field name incorrect I fixed that and it is working great thanks for watching this and all of your help.

I thought that the group statement I made might confuse the issue. what I mean by that is if you where to take the little test db and put two more sets of drop downs and buttons to reference more tables and queries.

Is there a limit to the number of selections and buttons that can be put on a form? I was moving happily along and can get 3 groupings to work as soon as put a 4th grouping on the form I get a message about it "#4" being to complex. The other 3 still work fine.

Thanks for the insight on this. I see now what i was doing wrong now. I forgot to put my between statements back into the query after I removed them. I had been looking at them for so long I didn't even notice until you pointed it out. Thanks again.

I know this is not much help but always back up before making changes and always work on a copy of the db not the working one.