Search results

No, that's a typo. I normally don't use brackets when the object names don't have spaces. I've tried the query both ways, with and without brackets, with and without typos...it still can't find the text box. Thanks for looking at my query--I don't see anything wrong with it either. I'm...

I've been writing queries in the following format for years in Access 2003, but having recently transistioned to Access 2010, I've found the following sql doesn't work. transform sum(s.value) SELECT s.sn, s.ln, s.pn, s.id, s.lat, s.point, s.supply_type, s.used, s.real, s.code, c.name FROM...

Hi. My name is Jim McDonnell. I've been using various versions of Access since 1997 and was once qualified as a dba for Oracle 8. My real job is in Engineering economics, but in my industry (electric and gas utility) the data requirements are substantial. I also use Access as a interface...