This was the syntax that I ended up using to get my answer. I also discovered that in order for me to get consistent answers, I had to round my Metric # to 4 decimal places.
floor([dimX]/1.5875) * 0.0625 as FinalValue
Thanks everyone for their help!
Sorry I meant to say 415.131256 millimeters mm -> decimals is 16.34375in.~
currently I have...
cast((round((itmdim.dimx/25.4)*16,0)/16) as decimal(10,4)) as [dimX (in)]
I am trying to take a metric number and convert it to a decimal, then round it to the nearest 16th of an inch.
Example 415.131256m -> decimals is 16.34375in.~
Here is were I am running into problems. I cannot seem to find the correct code to round that answer down to 16.3125. Everything I try...
Oh man. :O I'm sorry everyone i forgot to change the parameter to a number field. Changed that and everything worked wonderfully.
Told you it was probably something simple. I am so thankful its Friday.
Thanks everyone. Sorry again.
What formula would you put into record selection to pull in the data. I have tried a couple. Seems like any formula i use either gives me a "A number range is required here" or just does not pull in any data.
Hi everyone and thanks in advance.
I am using CR XI and Access 2003.
I have a database with information put in by job number(ex:227488, 227495, etc.) I am needing a report that allows the user to put in multiple numbers and it will only pull in those jobs. I am trying to use the Allow Multiple...
I am trying to open a .dbf file in CR XI and am having no luck. It gives me a "Failed to load database information" followed by "Unknown database connection error". The database is for our Time Clock system. Im not even 100% sure that CR can connect to one, but i believe it can. Could it be...
Yea it was an issue with the disk. It was a bootable disk, i just didnt see the scratch on it. I got a different boot disk and it worked just fine. Thanks for all your help.
I just bought a new hard drive for my HP s7613w computer and when I try and get it to boot to cd i get the "Disk boot failure, Insert system disk and press enter". It loads past the bios screen then goes to a black screen with flashin cursor then the error comes up. The disc drive is in higher...
I am trying to write an expression in access that after an item in a drop down is selected, if its ex: (1,2, or 3) then have a lbl say "Non-qualified" else "Qualified".
I have looked through the whitpages but did not find anything, but im not totally sure what the name is that im searching for...
I am trying to use StorageCraft but can not figure out how to boot to StorageCraft to replace the C: drive. I have read that you need a Recovery Environment CD but can not seem to locate one. Am i right in thinking this?
We are currently running out of space on our server and we require bigger hard drives. I was just wanting to make sure that if i used the backup utility that comes on SBS 2003, that i would be able to reload it back onto larger hard drives and not incounter problems. Any thoughts?
Thanks in...
Not sure if you have subreports in your report, but this is the way i solved mine.
I looked at how the subreport was linked then saved the subreport separate("Save subreport as" To desktop or anywhere) then deleted the subreport off the main report. Then i went back and readded the subreport...
When i try and open a report with CR XI on a computer it does not let me it gives me a "Parameter is incorrect" error and does not open the report. But if i try and open it on a different computer it works perfectly fine. Can someone please help me with this. When i tried to search this error i...
After your previous message i went and searched for dependant combo box and found it. I didnt know what they would be called. Thanks for all your help Remou. Sorry if i inconvienced you.
I am trying to make it to where if i select Maple in a Species combo box that then it changes the criteria in the PartID combo box to display only the ones that have to do with Maple. All Maple entries have a MaterialID of 1 and all Cherry entries have a MaterialID of 2. So when you change the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.