Recent content by kujospam

I have been looking for this for a few hours and maybe I'm just not searching the right way. I was trying to see if there is a way to convert text to a hyperlink in a query. Background : I'm pulling information from a lotus notes database using an OBDC connection and storing it into an access...

I have a bunch of records that are assigned to categories which are problem tickets. I would like to print the report showing not just the categories that have records open in them now, but also ones that don't have any records in them. So say I have these three categories. Power, Circuit...

I have the same problem. Let me know if you found anything out.

my access database has an odbc connection to it, with one table linked. Thats how I get the infomration into it at first.

I'm not sure if I'm going about this correctly. I have a linked table to Lotus notes that I cannot change at all, but for whatever reasons not all the columns are named right. So I copy that table over and have the columns renamed. ( I probably could rename them in a query, but sometimes when...

Thank you. I see what you mean. I had to do a CDate([From Date]), or around my parameter box. I didn't know I could do that, although I probably should of. I wish you could see the data types of fields in queries. Even though I know you cannot "change" them as you would/could in a table.

I uploaded a very slimmed down version of the database. I hope you can see what I'm trying to do. The Table cannot change, It normally would be a linked table. I'm trying to get it so that the "date" fields will become date/time fields. :banghead: Then to do a search on that for everything...

I got the above to work with the Date Serial, the problem is is still treats that field as if it is a text. I need it to be a date/time field. I'm getting datatype mismatch on later quries, even when I set the new field to be a date/time field.

The Date is stored as 2013-02-15 13:28:48 I tried this, but it is giving me compile errors. SELECT DateSerial(Mid(StartDate,1,4),Mid(StartDate,9,10),Mid(StartDate,6,7)) AS Expr1 FROM Secure_Access1; The Format I'm getting the same type of errors. I'm not seeing what I'm doing wrong.

The below no longer works. Update Database Query, I realize this is not an update yet. SELECT Secure_Access1.*, CDate([StartDate]) AS DateConverted FROM Secure_Access1; 2nd query is SELECT [Update Database].*, [Update Database].DateConverted FROM [Update Database] WHERE ((([Update...

I'm trying to create a query that will convert the text fields that have dates in them to dates. I cannot change the table this is linked to, our group does not own it. I tried doing a cdate() on it, and it displays the test as a date. But then when I try to run a query based off of this one...

I have a pivot chart that has site locations, and hours on the bottom, and then count of records with each site. Which is how many people used this site during this time for each bar. My problem is when I generate my pivot chart, every single time I have to fix the scale on the right hand side...

I'm getting my information from a calculated field in a query. That has total minutes.for each ticket. I was trying to use Format(([Total Time in Minutes]/1440),”hh:nn”) But I guess I don't know where to put this. I tried putting it under format. But after I copy it from notepad and save...

Thank you so much. That works perfectly now. I wasn't sure at first if it needed quotes, and when I did try it, I wasn't sure how to put them in. All I did was put the single quote before and after the double quotes around the cbo like you have them. Thank you a ton.

Sorry, I have been looking for the last few days on how to do this. Either I'm not searching right, or I'm the only person who had trouble following other people doing cascading combo boxes. I tried following microsoft example and several others but my problem comes up when I click on Group in...