I have database with a primary key that is 4 random numbers 0001-9999 is there a query that i can run that will give me all the numbers that are not used in that series?:confused:
i have a data file that is formated similar to this
A1111222223333344445555
B2222211115555444433333
i need it to be automatically imorted to a data base in the same order but each row formated the same such as:
A1111222223333344445555
B1111222223333344445555
any idea how i could do this so...
Still Stuck on this, I entered that string when pulling the report and am getting an error: Sytax error (missing operator) in expression query.... can anyone else help with this? :confused:
I have have 2 feilds in my database, there can be the same value in one feild but not both.....for example say NAME and ADDRESS i can have the same NAME for more then one entery and i can have the same ADDRESS for more then one entery but i cant have the same NAME And the same ADDRESS....anyone...