Rack for hotel management

[bubbu]

Hi All,

is anyone could help me on how to create a rack for hotel management ?
Since I can't afford VB, with macros results unuseful to achieve too.

I have a table "reservation" with exemple fields: name, dateIn, dateOut
I want create / transfer into "rack" table the name of the guest repeated as many time as the result from difference dateOut-dateIn . Beside the guest's name, each record have to contain the dates from dateIn to dateIn+1, dateIn+2, ..., dateOut

Exemple:
Table "reservation" record: pippo , datain:25/7/2020 dataout:30/7/2020
Table "Rack" records:
date:25/7/20 pippo
date:26/7/20 pippo
date:27/7/20 pippo
date:28/7/20 pippo
date:29/7/20 pippo



Thanks

[orange]

I don't understand Rack. But here are links that may be relevant to you.

sample room reservation
PBaldy Overlap

[bubbu]

thks, I'm gona check those !!

[ranman256]

docmd.setwarnings false


vDat = txtStartDate
vEndDate = txtEndDate
vName = txtName


while vDat <= vEndDate
  sSql =  "insert into table (DateFld,Client) values (#" & vDat & "#,'" & vName & "')"
  docmd.runSql sSql
  vDat = DateAdd("d",1,vDat)
wend


docmd.setwarnings true

[bubbu]

Many tks Ranman,
have I to put your code into a VB code, in a module or a class module ?

[June7]

Could put code in button click event.

[accesstos]

You can achieve this without code, but with an auxiliary table that has a field with consecutive numbers from 0 to n (30 in example below), as seems below: