Search results

Hi everyone, I have a problem with one of my queries. I suspect that it has to do with max settings for statements and characters. What are the respective maximum allowable numbers for both? Is there a workaround? I understand that I could simply split up the queries but I am running them from...

Select mytable.Fund_Name as Fname, mytable.Fund_ID as Fcode, mytable.Return_06_2010 as ROI, '01/06/2010' As [Date] From mytable Union all Select mytable.Fund_Name as Fname,mytable.Fund_ID as Fcode, mytable.Return_05_2010 as ROI, '01/05/2010' As [Date] From mytable etc. this seems to work...

@vbaInet not quite, I would like to stack the table (reduce it to three columns). The remaining columns are Fname, Fcode, ADate. There are several dates for one Fname/Fcode. Thus the relationship is n : 1

@vbaINet you are absolutely right, of course, but I'm stuck with the format of the table as is (because I didn't create it). There is a total of six tables. This particular table contains 200 columns (198 dates + Name col + Code ID col). I would like to revert to the (normalized?) table so I can...

Hi everyone, I have a table in my access database that looks as follows: Fname Fcode Date1 Date2 Date3 Date4 ...... DateN FundA 10001 30000 20000 12000 14000 ...... xxxxx FundB 10002 40000 50000 60000 70000 ...... xxxxx FundC 10003 99999 88888 77777 66666 ...... xxxxx ....... FundXYZ The...

Thanks for the quick reply

Hi everyone, I have the following SELECT statement below: SELECT Performance.ID As Code The entries for the Field 'Code' look something like this: 6473 4596 304 21 340 In the query I would like this to be changed to: 6473 mutual 4596 mutual 304 mutual 21 mutual 340 mutual What...

@Galaxiom: that is exactly what I suspected but I was very surprised that not both of them are null string. I have no information on how the access databases were compiled so that is to remain a mystery. @DCrake: sorry for the confusion, the back end is an Access database. But still no joy...

@DCrake thanks for you quick reply. Nz() is an Access function and works fine for the queries in Access. Any ideas how to implment it in SQL? thanks in advance

Sorry, jumped the gun there...The query below DOES work (Typo :() WHERE Information.UserDescription = '' OR Information.UserDescription IS NULL Alas, I'm still not sure why I have to use it, though...

Hi everyone, I have the following problem: I have two access databases that contain the same tables and fields within (it is an entirely different matter why the two have not been combined yet...). One of the tables is titled 'Information' and the field in question is 'UserDescription' (set as...

Sorry, my first attempt was complete nonsense...not very SQL proficient. The following for the second query seems to do the trick and is also very fast: SELECT Information.ID, Information.F1, Performance.Date, Performance.FundsManaged, Performance.Return FROM Performance INNER JOIN...

The following returns a syntax error and I'm not quite sure why: SELECT Information.ID, Information.F1, Performance.Date, Performance.FundsManaged, Performance.Return FROM Information INNER JOIN Performance ON Information.[ID] = Performance.[ID] WHERE (((Performance.Date)>=#4/1/1998# And...

ps the query has been running for 20 minutes now...no results :(

The problem is that the query just keeps running. Testing other queries, access usually displays a loading bar that shows me the progress in calculating the query. I have run many intricate queries on the same database that were resolved within a minute. My computer is a fairly new high-end...

If I change your last expression to: group by Information.ID having count(*) > 1) the query runs but is extremely slow. So far, I could not produce any results. Is there a shortcut?

Hi everyone, I have the following database with two tables named 'Information' and 'Performance'. I would like to run a Union-query to combine the information in the two tables. From the first table I include 'ID' as well as 'Fundname', from the second table I would like to include 'Date'...

Hi everyone, I would like to create a bibliography in access. So far, I have the following: Table SOURCE <Authorname> <Article> <Journal> <Year> Table AUTHOR <First Name> <Middle Name> <Last Name> I would like to create a form to enter new data with the four fields of Table SOURCE. A new...

Nevermind. I forgot to bind the combo box to the table entry. It works fine now. I intend to use froms from now on (Access newbie). Thanks for your help

Okay, I've created a form from the existing table. I changed the text entry for month to a combo box, set row source type to value and typed in the different values allowed (e.g. January, February, March, etc.). In the Form View I can now select from 12 different values. However, once I select a...