By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,984 Members | 1,016 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,984 IT Pros & Developers. It's quick & easy.

Ms Access DateAdd() Help in Query to Avoid Parameter Prompts

P: 1
I am trying to determine a Term date. I am using a DateAdd function in a query. Formula. DateAdd(m, [termLength], [inservicedate]) the query accepts this formula but when I try to run it asks for parameters. I would just like this to be a calculated field. Any help would be greatly appreciated!!
May 20 '19 #1
Share this Question
Share on Google+
3 Replies

Expert Mod 15k+
P: 31,347
Well, to know where to look we'd need to know what parameter(s) it asks for.

If the references within the square brackets [] should be resolved without the need for prompting the operator then they need to match Fields from the FROM clause of the query. I can only assume they don't, but more than that it's impossible to say without more information.
May 21 '19 #2

Expert Mod 15k+
P: 31,347
Also, it's hard to say for sure because some people actually type their code into a question instead of using Copy / Paste, but what you've used as quote characters in your code aren't actually quote characters at all - as you'll see now I've added the [ICODE] tags for you.

Never use a word processor to work on code for exactly that reason. It will replace various important code characters with ones which only make sense visually - thus breaking your code.
May 21 '19 #3

Expert Mod 5K+
P: 5,387
More than likely, as Neopa states, there is a typo in your field names.
If you would, let us take a peek at them by doing the following:
Open your query in design view
In the lower right hand corner of the access window you should see a series of icons, one of which should be "SQL" double left click
You should see a bunch of text, most likely starting with the word "SELECT"
Select (no pun :) ) all of the text in that window, copy, and paste it directly to this post
Once inserted, select the text within the new post and click on the [CODE/] formatting tool to place the code tags Neopa mentioned above.
May 21 '19 #4

Post your reply

Sign in to post your reply or Sign up for a free account.