Search results

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...

are you still holding shift after the security warning? not just when you initially open it?

hold the shift key down when opening, i ran into this problem myself a couple days ago.

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:

do you think you could show me on this example then repost it?

thank you :cool:

im having some trouble sending the results to a report to print in mine, can you add that to the example then repost it? thanks

i have a search form with a sub form displaying the results, how can i send the results to a report to print out or just print the results?: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...

Ah, Found it! Im new to access, was looking in the wrong place....Thank you! :D

i dont know, im using Access 2003 and dont see that option.

i need a report that will show all duplicate records in a certian feild, if anyone can help me with this i would aprecitate it.:confused: