Search results

if the bestellnumber field, then yes, I had a one to many relationship for that as I need to have several ordered items on the bill

Which field are you referring to?

Re: Ordering System, Form with subform I did try that at some point, but I still had the issue that "bestellnummer" in the subform wasnt being updated with the "bestellnummer" created when opening the form up.

Hi, Im creating a database for a pizza business in Germany so please excuse the german Field names lol. So ive started it, created my many to many relationships and also created a Form with 2 subforms, one to display the customer info and one to actually take the order (datasheet view) I can...

Ive found other people mentioning that webpage regarding a room availability query, and how its explained on the website it does seem perfect for what I need. But I need help with the SQL code: SELECT Driver, OffStartDate, OffEndDate, Reason FROM tblSickVac WHERE OffStartDate <=...

I'll be home soon, ill have a play around with the parameter query. I had a look at that SQL code, the code itself seems simple enough but Ive never dabbled with SQL, i don't even know where I would input that code :/

help..please? lol I would also need to input two sets of dates, the arrival and departure date.

Thanks for the reply, that page seems like exactly what I need but I dont quite understand how I meant to translate that into a query. As you can im still quite a noob when it comes to access.

Hi guys, I have made a booking system in access which works brilliantly. There is a feature I would like to include and I thought I would ask you guys, as last time you was able to help as well. Essentially I want a query which will ask me to input the required dates of the booking and I want...

Absolutely brilliant :) Thank you guys so much! Its working like a charm! Thanks everyone for your input

I dont think this is it, the filter needs to be worked around which week I open the query. So if I open the query on say the 17th June, which is week 2, then the results will list all the apartments which were assigned Schedule2. Do you see where im coming from?

I thought perhaps something could be added in the Criteria field of the query in order to filter it out. If a second query is needed, that is fine as well. So essentially this query shows which apartment belongs to which schedule and the second seperate query will show which apartment will...

Thats not quite what I am after, that essentially shows me in which week number the client arrived. So, if I open the query in Week 1 or 3 of the month it will only show the apartments which are in Schedule 1. I hope I explained that properly :)

This all working well, I would like to another step if possible. Now its set up to show which apartment is to be cleaned when, can I set another filter on top so it will only show which apartments will have to be cleaned this week? So schedule 1 is Week 1 and Week 3 of the month and Schedule 2...

I understood what you meant after arnelgp's post :) The reason I have spaces in the Field Name is for the report I created which prints out the Bill, but I will keep a mental note to keep things simple where I can. Thanks

That did the trick! much appreciated!

Thanks for the swift response. Right of course, since there is only two answers a normal if statement is enough, makes sense! I tried that, it didn't work (syntax error) and then I also changed the () around Date of Arrival to [] like this: Schedule:iif(day[Date Of Arrival] between 1 and 7 or...

Hello All, Ive made a booking system using access and I wanted to create a cleaning schedule. Essentially I want this query to look at the date of the arrival and then allocate that client to either Cleaning Schedule 1 or Cleaning schedule 2. Clients arriving during 1st - 7th or 15th-22nd will...

Hello all, I am currently in the middle of creating a database as a means of keeping records of vouchers codes. The idea is....when someone uses a voucher, I will then be able to input the name of the customer with the voucher code in the form. This is meant to do two processes: 1. Keep a...