Search results

mmm, ok if an admin could shift this over to vba section that would be great. How can i do this with vba?

Hi, I have a cross tab query that has field names 6, 7, 8, 9, 10 representing months and a relevance date field with a date. I have a form and from that form i need to get the value of the last three months from a relevance date field. I.e relevance may be 01/10/2005 so i would need 3 labels...

no, it was set to decimal, but i have changed it to both of them and it still does not work. Thanks

mmm, any idea?

Hi, I have the field set to number -> decial and places to 2. The CSV document reads 96.133542682 So once imported it should look like 96.13 but it doesn't it is just 96. Why is this? when the field is text it is the 96.133542682 as it should be. Thanks k0r54

i see :) Thanks for you time :) k0r54

it doesn't seem to work, it doesn't group by the fs-id

Ok, thank you for all your help. Have just changed the format to american and all is well :) Thanks for every Adam

Ok, it deffinatly is that. Is it possible for it to be in the table as american

Ok, I have checked everything and still no luck. I have simplified my query by JUST have the date field and still nothing. I THINK what the problem is.... I have my machine and access set to UK i have input the field as mm/dd/yyyy (American). If i was to use the format([start...

Hi, I have a table with 3 fields in: - FS-ID Availability Relevance Date Every month i input the availability for the id and put the relevance data as 01/06/05, 01/07/05 etc... I am now doing a query where I want to see all the months for the line address but rather than is being:- field1...

It is set to UK i have put them in there as mm/dd/yyyy, still no luck. ; says invalid syntax It works fine though when i put in the two dates just doesn't when im doing dateadd :s All your help is appreciated Thanks k0r54

Thankyou, but it does not work still :(. My date in the table is mm/dd/yyyy so i changed them both around and still nothing. It is in a query and i will be gettin it to popup for the dates i.e [Date:] Thanks k0r54

Hi, When i use this between #01/07/2005# and #01/09/2005# It all works ok and pull outs what i need. But when i do between #01/07/2005# and DateAdd("m",3,#01/07/2005#) I have also tried it without the # and with 2 instead of 3. No luck :( Any ideas? Thanks k0r54

Hi, I need to name my field in my select query i.e : - name: [... but instead of it just being text, i need it to calculate its name by month i.e Month([Starting date:])+1 On my query i ask the user to input a starting date and i then work out information based on that. How can i name the a...

Hi, How can I export 2 seperate select querys into a single excell workbook. I have tried transferspreadsheet but it just does one (apart from i cant get it to pick up the query, just tables). I need it to put one query into a 1 and and the 2nd query into another sheet preferably being able to...

well i didn't know about that lol :) Thanks very much :)

Yeah, i also tried that, but unlike MySQL you can't put a LIMIT to just 1 record. Otherwise i could desc and just take the first record.

I have tried that and dmax but it still wont work, well dmax works but it needs to be in a different query, which i REALLY want to avoid.

Hi, I am using this sql query : - SELECT Monthly_below_report.Device FROM Monthly_below_report GROUP BY Monthly_below_report.Device, Monthly_below_report.[FS-ID] HAVING (((Monthly_below_report.[FS-ID])=780)); The problem is this currently pulls out 5 records (all devices found and the amount...