I will run this query on the attached:
SELECT Staff.StfLastname, Staff.StfFirstName, (Cdate('2007-10-01') - CINT(dateHired))/365 AS years
FROM Staff
Order By stfLastName, stfFirstName
I have changed the name of fields, but result set comes back as #NUM! for some of fields? what is the reason?
Regards,
GGGGGNNNNN
Access: the query brings back #NUM!
-
- NewLounger
- Posts: 2
- Joined: 04 Feb 2014, 05:20
-
- Administrator
- Posts: 78666
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Access: the query brings back #NUM!
Welcome to Eileen's Lounge!
Could you create a copy of the database, remove everything from the copy that isn't needed to demonstrate the problem, then zip the copy and attach the zip file to a reply?
(See Tip: adding an attachment using the prosilver skin for instructions on attaching a file)
Could you create a copy of the database, remove everything from the copy that isn't needed to demonstrate the problem, then zip the copy and attach the zip file to a reply?
(See Tip: adding an attachment using the prosilver skin for instructions on attaching a file)
Best wishes,
Hans
Hans
-
- NewLounger
- Posts: 2
- Joined: 04 Feb 2014, 05:20
Re: Access: the query brings back #NUM!
I can't activate any button to attach my file. Thanks GGGGGNNNNN
-
- gamma jay
- Posts: 25455
- Joined: 17 Mar 2010, 17:33
- Location: Cape Town
Re: Access: the query brings back #NUM!
Hi,guityn@cox.net wrote:I can't activate any button to attach my file. Thanks GGGGGNNNNN
Did you look at the link that Hans provided in the above post? It has full instrctions to upload a file....
First you must make sure that you are in the Full Editor Mode.
Easiest way to do this is to click the Quote Button in the post you want to reply to.
Then click Upload Attachment (your zipped database)
Cick choose file and browse for the file
Then click Add the File
Once in full editor mode, follow the screenshot as below:
Note: The screenshot below is taken from the Prosilver skin. If you have a different skin, it might look slightly different, but the process is more or less the same.
You do not have the required permissions to view the files attached to this post.
Regards,
Rudi
If your absence does not affect them, your presence didn't matter.
Rudi
If your absence does not affect them, your presence didn't matter.