Recent content by NightSpy2

My Customer table is quite like you said, but I don't quite understand what you're doing with the HireType and CustomerHires. I've uploaded an excerpt of my database, so if you could tell me more specifically what is wrong / how to fix it, that'd be great! :) I know that having CustomerID's...

Ok thanks. Yea no problem, I know you don't intend to sound mean. So how can I 'normalize' my database? :)

Hi there I have a form with two unbound text boxes: HireMovieID and HireCustomerID, and a button HireButton which runs my query: HireHistoryQuery. Then I have a table: HireHistory. In my HireHistory table, I have my CustomerID's along the top as column names. Then the records for those columns...

I forgot to delete it because I was copying my data from my CustomerInfo table. Ok thanks! :)

Oh ok. I've got a table Hire History, and the data in it is laid out like this: Is it possible to make it so that when (for example) John Smith hires something, it adds another cell to the end of his hires in this sort of format?

Hey guys! I've got a problem which I can't seem to figure out the code for. I have the logical process, but I just don't know how to put it into code. I have a form with two boxes HireMovieID and HireCustomerID, with a button HireButton. The two tables which I have are CustomerInfo and...

OH MY GOSH! I finally did it! Thanks everyone for your help. I tried writing my own SQL and it finally worked! :D I'll post it up later on when I can! :)

Yes I know that you said that, but in the code that you showed me it has an '=' operator, so what I was wondering is that if I used your code, would I need to type exact values in order for the records to be filtered. Does that make sense? :o

But I need LIKE for my Name/Rating/Genre etc boxes? As in so that they don't need to type in the full name for it to work. Will that still happen with this code? Because it looks like '=' so the text has to be exact, am I right? I need it to show records even if I don't enter anything into some...

This is all of my SQL: SELECT MovieList.[Movie ID], MovieList.Name, MovieList.Rating, MovieList.Genre, MovieList.MovieYear, MovieList.Director, MovieList.Length, MovieList.Status FROM MovieList WHERE (((MovieList.Name) Like "*" & [Forms]![SearchForm]![Name] & "*") AND ((MovieList.Rating) Like...

:banghead: ^That's exactly how I feel right now. The thing I've been trying to do is make it so that my form filters my records, and I'm trying to make a between function for it. My form is shown below in the attachment. What I need to do is make it so that my form filters my records Between...

It shows all records :) Exactly what I needed

Thanks for you help. I've got a solution now. I used the code: WHERE Between [Forms]![SearchForm]![MovieYear1] And [Forms]![SearchForm]![MovieYear2] OR [Forms]![SearchForm]![MovieYear1] Is Null and it seems to work perfectly. Do you recommend I change it to yours, or does this...

Ok I put it in as in my SQL code under the WHERE: ... AND ((iif(isnull([Forms]![SearchForm]![MovieYear1]) or isnull([Forms]![SearchForm]![MovieYear2]), true, [MovieList].num between [Forms]![SearchForm]![MovieYear1] and [Forms]![SearchForm]![MovieYear2])=true)) AND ... And when I try to run...

Hi, I have two text boxes and I'm wondering how I can filter my records of my table (through my query), between two numbers on my form. So for example lets call the two text boxes Num1 and Num2, the logical process is: IF Num1 or Num2 IS empty THEN filter records with "*" ELSE IF Num1 and Num2...