Search results for query: *

Hey All, I have been searching all over the web trying to find a solution to my problem. I have a FE and two BE access database. One BE is used to house the table that is modified by the user and one BE that is to be used for reference only. My problem is this, when I link tables from the...

-------------------------------------------------------------------------------- Alright guys, I am beating my head against a wall with this one. I am a new access programmer . Here is what I have; One MDB that has a couple of tables for storing data and another MDB that will be used as a...

Hey Guys, I have some code that converts a range to HTML for insertion into an email body. It works fine and dandy on my machine that has VBA 6.5 but when someone tries running the code that has VBA v6.3 they get an can't find object or library error. I cannot find the reference to enable to...

Thanks PHV, Worked perfect.

Hey Guys, I am sure the answer to this is very simple I just can't find it anywhere on the net. What is the function in Jet SQL to convert a date time (07/13/2009 13:30:00) to just show the time (13:30) Thanks

Nevermind, that was my problem...removing the brackets in my Toad query. Thanks for responding....

It runs ok when I do it from access (i need to put brackets around the derived tables for access to be cool with it) but it works.

I am using toad to query an MDB. When I try to run the below query I get a "Microsoft Access ODBC too few parameters expected 1" error. Anyone have any thoughts? Thanks SELECT DISTINCT agtdata5.AGENT_ID, agentA.AGENT_NAME, agentmap2.HIRE_DATE, agtdata5.MU_ID, agtdata5.AGENT_DATA_VALUE...

Thanks PHV, I have tried using the IIF() and Switch() functions however when I have more then 15 conditions in either of them I get a "expression too complex" error. I would normally just create a table in the MDB with all the lookup values that I would join however the lookup values are...

Thanks, When I try to query my MDB ODBC via microsoft query I get the error "Undefined function 'CaseSearched' in expression" here is the SQL I am using SELECT Schedules.AGENT_ID, Schedules.AGENT_NAME AS 'Agent', Schedules.AGENT_DATA_VALUE AS 'Supervisor', Schedules.MU_ID AS 'MU'...

Hey Guys, I have an access database as a store for some data. I have a custom function in my MDB that is basically a CASE statement. It works when build queries within the MDB itself...is there a way I can call on this function when querying the tables externally via an access ODBC...

Sorry, Here is the SQL I am using SELECT Schedules.AGENT_ID, Schedules.AGENT_NAME AS 'Agent', Schedules.AGENT_DATA_VALUE AS 'Supervisor', Schedules.MU_ID AS 'MU', Schedules.HEADER_DATE AS 'Schedule Date', Schedules.DETAIL_EXCEPTION AS 'Detail Exception', SWITCH(schedules.DETAIL_EXCEPTION = '1...

Hey Guys, I have a bunch of data stored in an MDB. I am using microsoft query to query it and pull it into excel. From what I understand Access does not support Case statements so I decided to use SWITCH instead. The problem is when I get past 15 conditions in my SWITCH statement I get a...

Hey All, Does anyone have some SQL to get me started or maybe a link to a help guide that will get me started? I have a table with schedule exception detail that I need to summarize into half hour incrememnts. Here is an example of what the schedule exception detail looks like. Exception |...

Got IT!! I just had to add a few () and it worked. Sorry guys, I had no idea that Access treated the code different the SQL server. Thanks so much for your help.

I am actually just querying an MDB 2000 file format from access...

Just tried that...same error. WHen I try the the derived table Join by itself it runs, and then whey I try the first join by itself it runs. Something is goofing up when I try to join those two together though.

Hey Mark and George, I tried both of your suggestions and I get the exact same error at the exact same spot. Here is the last SQL i just tried SELECT ScheduleDATA.AGENT_NAME, ScheduleDATA.HEADER_DATE, agentmap.MU_ID FROM ScheduleDATA Inner Join agentmap On...

Hey George, So duplicating your example I built some SQL that uses my actual tables and I get a "Missing Operator" error starting at "ScheduleAta.AGENT_ID = agentmap.AGENT_ID" Can you see anything I clearly missed? SELECT ScheduleDATA.AGENT_NAME, ScheduleDATA.HEADER_DATE...

OH man thanks so much. I actually new I had to do some kind of sub query or "derived table" as you call it I just could not get the syntax right. This actually makes perfect sense to me now. I appreciate it greatly!!!!