Search results

i dont mind having a look

<160 would limit the records displayed to 160 or less, but i'm not sure if thats what your trying to do, are you trying to limit the number of entries that can be entered for each night??????

yep that worked, and no you dont need the #'s cheers mate

still have a problem, when i do that i get an error "Between operator without And in query expression"." here is my sql SELECT DISTINCTROW tblCustomers.Account, tblCustomers.CompanyName, Count(*) AS [Count Of tblEnquiries], Count(tblEnquiries.EnquiryDate) AS [Count of EnquiryDate] FROM...

Thats great Thanks alot

I am trying to build a query that shows me the activity of my customers. I have a database that amongst other things holds two tables which i am trying to query. tbl 1 - Customers tbl 2 - Enquiries What i eventually want to do is create a report that shows which customers have made enquiries...

after reading your edited question, the most simple form of preventing people from editing or deleting records would be to disable these options in a form and not only users access to your queries or tables other than via your forms. this can be done during the design process by bringing up the...

hi, what i would suggest you do is search this forum for your answer, this has been discussed many times and there are many different answers from many different users. For an example of how it can be done have a look in the sample databases forum and you will find a log in example which shows...

I don't see why only having 1 indicator id would affect you being able to have a seperate field for "value" and "count" at the end of the day it is the "ID" field i.e th PK that will hold this information together. To do this simply use a form with a subform (a wizard can do this pretty much...

come on guys someone must know how to do this, please help

umm lets see...... I run 3 multiuser network databases at work. In addition i have in my time created 6 websites running on a access backend through ODBC links. Access was initially designed with the idea of using it as an office level database system. Who told you that access should not be...

I know you can create a find record command button really simply, which when clicked will display the find and replace window. What i want to do is create a command button that will search a specific field that i specify in a report for the criteria i enter. i.e i have a customer information...

ummmm, i have this exact same problem. If you manage to figure out what is causing it and how to stop i would really appreciate it if you could let me know. Thanks

in the report you can create an unbound field and use the following code to obtain the data. =Sum([Price]) put this field in the report footer and it will add up all your price entries. with regards to setting the dates to show i would enter something like a date field to the table. that way...

In my report i have a number of enquiry entries that have been authorised. To specify whether this has happened the database has a yes/no format in the enquiries table. I have included this field in the report but in the summary of the report for each customer i want to calculate and display...

One more question if you dont mind. In my report i have a number of enquiry entries that have been authorised. To specify whether this has happened the database has a yes/no format in the enquiries table. I have included this field in the report but in the summary of the report for each...

thanks for that john, your a star

the criteria i would use to display the previous year value would be Year([yourField])=Year(Now())-1

Is it possible to create a report from a table or multiple queries that show every entry and non entry in a database???? What i am trying to do is as follows.... I have a database that has a table holding all my customer information and a table holding all the information regarding their...

Does anyone know if it is possible to add a pop-up message to an individual record in a database? and if so how do you do it??? I have a database which holds infomration about suppliers, some suppliers give us fixed prices for some products to general customers but they also offer another price...