I make a database for theatre tickets selling system. There are tables with theatres, spectacles and sessions of spectacles (one spectacle can be showed many times). In table with sessions there is a date field. I need to make a form, where user can choose a theatre and a month, and will get a report with a list of sessions in chosen theatre for chosen month. Does anyone know how to do it?
我为剧院门票销售系统建立了一个数据库。有桌子,剧院,眼镜和眼镜(一个景观可以多次展示)。在包含会话的表中,有一个日期字段。我需要制作一个表格,用户可以选择一个剧院和一个月,并且会在选定的剧院选择一个月的会议列表。有谁知道怎么做?
1 个解决方案
#1
0
i guess you are searching for the Month Function.So when you select a month you need to perform this on the query :
我猜你正在搜索月份函数。所以当你选择一个月时,你需要在查询中执行此操作:
WHERE Month(DateOfSession) = " & me.cboSelectMonth
#1
0
i guess you are searching for the Month Function.So when you select a month you need to perform this on the query :
我猜你正在搜索月份函数。所以当你选择一个月时,你需要在查询中执行此操作:
WHERE Month(DateOfSession) = " & me.cboSelectMonth