Search results

I know you guys probably would like to throw me a stone to the head BUT, would it be possible to calculate this based also in the Hours and not just in the days? so that we can get like 1.5 days and not either 1 or 2 exact days

Hi all, I created a Query in Access that is picking up data from only one table. The intention is to create new fields in the query using IF statements like COMQ2: IIf([Resolution] Like "*COMQ2*","COMQ2"). I use this query in a PivotTable Object where the field COMQ2 is available. The...

thanks for that, I'll give it another go.

Hello everybody! I have a website made with Access. This Access .mdb files and the related web pages are secured with an Access .mdw file. Therefore when a user loges in, he can put his own personal password. Is there anyway to store the password in a session? I mean, each time the user goes...

Hey, thanks for the prompt reply! I've been busy like hell hiting my head against the wall with this. As you know the issue is that when I do a count of authors in a pivor report, it counts as there are 6 authors. I was hoping that you can actually create a calculated field that will count...

Hi all, I have a bit of a problem with my query. I'll try to explain this in a simple way. Imagine you have a table with authors' names and another one with the books they wrote. When you put the tables together in a query it comes in like Dan Brown Angels and Daemons Dan Brown...