Bitwise Operations?
Nov 10, 2006Do queries support bitwise operations:
IE:
2048+512+128 = 2688
Field1 = 2688 in the table
Query:
MyField: ([Field1] And 512) = 512
etc?
thanks
Jaeden "Sifo Dyas" al'Raec Ruiner
ADVERTISEMENT
Date Operations
Aug 13, 2007Hello everyone,
I need help in writing a query that would return the records that are not older than two weeks.
I would appreciate your help in advance. :o
Using Operations Between Tables
Sep 25, 2011I have 3 tables in my database.
How can i use oprations between my tables?
For example: I have 3 tables named "Input,Output and Available"
When I add for example "2 Hard-Disks" in Output, 2 of Hard-Disks deletes from Available Automatically....
Operations Must Use Updatable Query?
May 23, 2005Please help, this error is wreking my head:
I have a VB APP updating a an Access DB, i get this error every so ofter:
-214 (load of numbers) Operation must use an updatable query.
I have given full control to to the directory on which the App and the Access sit..
any ideas?
Math Operations On Values Question
May 13, 2005I have created a table that holds the inventory information of some items i have in stock. What I want to do is this:
1.)When a customer orders something, i enter the quantity ordered and hit a process button. When this button is clicked it automatically reduces my inventory count to reflect the reduction
2.)When I receive shipments, i want to enter the information and hit process so that it automatically sets my inventory counts to reflect the addition of the new units
I am having trouble figuring out how to go about doing this. I was thinking of somehow setting up some textfields and then adding buttons that set fields accordingly.
Any help would be most appreciated.
Queries :: Checking Query For Null And Setting Operations
May 30, 2014I have been working on an application where I am collecting survey data in a database. There are multiple survey tools available to the user, and it's possible to complete multiple survey tools in the survey.My problem is, it's possible for the surveyor to complete some tools on one day and other tools on another day. I am having problems with trying to figure out how to add a tool that has not been previously added and keep in the same survey which is all held under a single Survey Number.
The first step in the function is to set a Record Number temporary variable based on whether or not the tool has been used (it's possible to use multiple instances of a survey tool, so need to know if the Record Number is '1', or the next number in the sequence.I've been trying to do this by checking a query for a Null and setting the temporary variable using something like:
IF ISNull("RecordNumber","qryRecordHeader") Then '1'
Else
DLast("RecordNumber","qryRecordHeader") +1
End IF
The second half works just fine, so if there is a previous record, it will add. But if it's Null, it doesn't work.I'm trying to avoid opening a temporary form to run the query and checking a field. Is there a way around that?
Forms :: Linking Form Operations To Values In A Field
Sep 8, 2014I have a combo box field called "investigations" on a patient database which can allow multiple values. Each of its values represent the different investigations a patient can do. Now those investigations are tables and forms in the database. how can i program the database to simultaneously open these forms "on update" of that field-investigations?
View 1 Replies View RelatedGeneral :: All Operations Based Off Of Newly Entered Date
Apr 30, 2013I am looking to (on the mainform) have the user enter into a text box whatever date they would like to enter and have that value become the current date of the system. So that all operations are based off of this newly entered date.
View 4 Replies View Related