Search results

This form is linked to a report that is based on a query that this done on a My SQL Db Tbl that stores the "Updated" date Is that what you mean? .... Sorry I kinda new to this VB and MySQL issue

Hello, I have a date range form that has Start Date, End Date and Preview Report command button. In the OnClick Event Prod I have Dim strDateField As String in my code that should connect to a MySQL Db, to a table that stores the UPDATED Date. The problem is I can't seem to get the form to...

I think I spoke to quick ..... Um .... maybe its me ( I think it is ) but ...when I switch to Pivot Table view and drop the fields I want .... it goes a lil crazy .... here is a screenshot http://www.mts.net/~and0215/crosstab_pivot.jpg Can someone tell what I'm doing wrong ? Thank you...

Brilliant! wow .... Thank you very much David ..... like really man .... and thank you all for assisting me .... this is SO appreciated Bless you all! ! ! ! ! ! ! ! ! !

this is my ultimate goal .... if possible http://www.mts.net/~and0215/pivtoltblrpt.jpg

1st off ....I just want to thank everyone that has and still is helping me with this ...it is really ...really ..really appreicated! Okay ... I have done as you asked and it seems to work ... but in the MINS fields I'm getting #Error Here are the screenshots...

Okay, I have 2 tables 1 - tickets - is an MySQL tbl 2 - Departments - is an Access tbl I am attempting to create a Pivot Table Report :eek: (yeah i know) From my tickets tbl I select the following Grp(dept), C29(subactivity), C30(Time spent on activity), Oper(Service rep Names) Under...

Hello, Here is a screenshot of my query http://www.mts.net/~and0215/QueryScreenshot2.jpg it still displays the items that are suppose to be exclude ...why ? any help is appreciated thank you in advance.

I'm an Idiot! .... it works now I should have had this Expr1: Format([C30],"Short Time") and NOT Format([C30],""hh:nn") One last question ....I hope :) how would I go about adding/summing the time now ....... I know I know ....it never ends :) Thank you in advance

In FIELD - I entered Format([C30],""hh:nn") and i'm getting the same error Here is a screenshot of my query http://www.mts.net/~and0215/QueryScreenshot.jpg

this is what i have Expr1: ([C30],"hh:nn") and Access doesn't like the comma

I just tried what you suggested and it didn't work I'm getting "the expr you've entered has an invalid string" error

Hello, I would like to format the time to read as [hh]:mm in my query Note *** I already have a "does not equal" value in the same query on the same colunm/field How do I do this? Thank you in advance

Okay ...now that I have solved that issue .... I have another ..... my users enter their time via an online form ..the time itself is entered from a drop down box .. :15,:30,:45,1:00 ....etc in MS Access, I run my query and it displays the data .... But when I switch to Pivot Table view...

Damn it! ...I had a feeling it was going to be simple! .... Thank you very much Paul! it worked!

Hello, I have 2 tables Tickets and Departments in the tickets tbl the "departments" are listed under column GRP as group1, group2, group3 etc.... in the departments tbl the "departments" are list under column Deparment as "Sales","Billing" etc I would like to run my query and have the...

LOL ... Okay .... I will try to explain the issue ..... I have 2 tables ... Table A and Table B. - One record from Table A matches with 3 or more records in Table B (this would be a one to many relationship ..right? - I would like to select a value from a drop down (Table A) and have the...

Wow .....Thank you so much ...like really .... this exactly what i needed ! ... Thank you DK

I zipped it up for yah ...... Thank you in advance

Nevermind......I just tried ...it doesn't work : (