Search results

There's not much difference between a side car and that huge, lumbering and clumsy pan!:p Now, the R6....:D

It might be an idea to have a noob forum where newbies like me don't feel like an idiot for asking simple questions. It could have stickies for the most common questions. The top sticky would have to be froum rules: search before you ask, what info should be in question etc... A sticky for...

Wouldn't you need to use Nz() on each field rather than using it on the sum of them? If only one of the above fields is null, wouldn't the whole expression work out to be 0 or #Error#?

Thanks for the post, but I may have 50+ dates and about 12 staff. Having the dates as columns and the staff as rows would cause even more headaches. I can't believe Access doesn't support crosstab reports with dynamic columns. I'd have thought it was such a common requirement.

Where are you putting the answer to this calculation? You've posted in the 'tables' forum. If you want to put the result of this equation in to a table, you shouldn't/can't. Tables shouldn't/can't store calculated data. You need to perform this calculation each time you want to display the...

If anyone's still interested I found a work around by using a PivotTable as a sub form. It's quite messy, and doesn't give you any format abilities but it works.

Sorry, I was talking crap there. You can't use a crosstab as a subform. How are you getting on? I've done quite a bit more to mine.

No, the above work around doesn't work. :( I get an error message saying i can't use a query with an unfixed number of columns as a sub report. Is it possible to export the table to a pre-formatted spread sheet in excel? I'll workout for my self how to do it, I just want to know what route to...

I've found an interesting work around: http://www.dbforums.com/showthread.php?t=1605962&page=4 It uses the crosstab query as a subreport. It's not ideal as I cant do the formatting I wanted to, but it will display new columns.

Solved it if anyone's interested (quite a common problem by all accounts). In my example it was because VBA will only work with dates in the USA format. Regardless of system settings. I had to re-format the date from UK to USA format (mm/dd/yyyy) at the beginning of the function. When the...

I'm replying to the pm here as it wouldn't let me send such a long pm. In my db it's the supervisor that enters the data for everyone, so access to each other's data isn't an issue. 1.) My initial thoughts would be to crate a table of staff ID's and passwords. 2.) Create 2 forms. One's...

Managed to get it working. Thanks. The problem I've now got is the number of report columns doesn't change if the number of crosstab columns change. The info I've seen on how to create a report with a variable number of columns is very complicated. The examples I've found don't have a similar...

totals query? Forget question 3, I've updated WorkedHours() to calculate it.

Don't worry, this isn't about parameters. I've searched the forum and can't find the answer to this (but loads on crosstab perameters!). I have a table: DateWorked | StaffPIN | StartTime | FinishTime | ShiftType ------------|-------- -|-------- --|-----------|----------...

I suffered similar problems to you with a similar database. My problems were solved by normalising my tables. The two .png's were intended to show you how I did this. I have not yet had any problems with this structure. I asked people to check it as I didn't want to give you flawed advice. I'm...

reading that back, I think I could get rid of the otherHours table, the ShiftType field of the Hours table would be sufficient to identify if the shift is chargeable or not if I put a chargeable/non-chargeable flag in the shiftType table . Thanks.

The Hours table records the hours that are chargeable to the client. ie, the hours that the staff members actuall spend doing their job. The 'other hours' table records the hours that the staff spend doing other stuff. This will include authorised/unauthorised absences, training hours, holiday...

I'm trying to do a similar thing, I spent ages on the 'old' db to no avail. I changed the table structure to the 'new' version. So far it's making things easier, can anyone spot any pit falls I might face? Edit: Have changed the new table structure since I posted this, nearly finished the...

Would this be any be any better?

With this example, can one employee work more than one day? It would also mean there'd be multiple entries for the same day. I'm not trying to argue. In my ignoance I don't quite follow you.