I have a table as follows:
ID      Forename  Surname
------ ------------- ---------------
2       John          Rodgers

I have a common stored procedure (SP) that has a variable containing a
database name passed to it. Within the SP I have the statement "Use
@databasename" but get an error when I run the SP. I then defined a variable
that holds all the SQL statements (including  the “USE ...

I want to do a "As" query in SQL.  In Access, Query Designer, you can
specifiy in the criteria field something like:
Field name:  From: DT_RDG_TO (so my field is called from)
[Reading Cons Detail - CU04TB36]![DT_RDG_TO]-[reading header -

I have some models that have hyhen in between. e.g.1200LD-VCD, abc-1234
May I know how to remove the hyhen.
Thank you

Yes, I certainly am not a programmer. Access gives me enough of a headache.
What I'm after is some advice.
Me and my brother run a small business and we have decided to have a
database developed specifically for our business. The question is what do we

i have some models that end with +SP e.g. 1234+SP, abcd+SP I want to remove
only the +SP from these models. May i know how can i do it. Thank you