Search results

In one of my reports I want to print a word document. My problem is that it prints only the first page of my word document. What can be the problem?

I have a form where I insert data into two tables: reservations and clients (which its primary key is clientid ) (each reservation has one client .the linking field is clientid) In order to insert new reservations I built a form where the user inserts the reservation data (including clientid )...

I have tried something and it works. first I wrote the first query (called q1): SELECT voucher.ordernum, Min(voucher.vouchercode) AS Minimum FROM voucher GROUP BY voucher.ordernum; And I used it in a second query: SELECT DISTINCT q1.ordernum, q1.Minimum, voucher.vouchertype FROM voucher...

well... I managed to write the following query: SELECT Voucher.ordernum, Min(Voucher .voucherCode) AS Minimum FROM Voucher GROUP BY Voucher .ordernum; It creats a table with two fields: the first-ordernum-the orders numbers the second-Minimum-the lowest voucherCode for each order num. My...

I have a table named Voucher with 3 field: voucherCode (every voucher has a unique code) ordernum (there can be many vouchers with the same ordernum) vouchertype The query that I cant manage to build is a query that returns a table that each row contains 3 field: ordernum (grouped by)...

It works... Thanks for the help.

I have a form where the user types in a part of a name and then he can view the details of all the people that their name has that string. But I am having trouble writing the query that will do this...I have tried using: WHERE fieldname LIKE '*[forms]![formname]![controlname]*' Hoping that if...

I have a table with details about hotels including their name and address. In one of my forms I have a combo-box where I can select the hotel area and a second combo-box that display the name of only the hotels that are in the area selected in the first combo-box. My problem is that in certain...