Search results

i have several forms on my DB that are based on a select query's with a criteria of 'date' I have tried to set the format for this as 'short date' to avoid having to put in the / every time (this works on a report) but despite saving this format when i close the query the info is lost and so the...

does anyone know if it is possible to add a post code checker/search to access, if so do you know of one which works. I want to be able to bring up an addess by post code/house number in the UK

Is it possible to take the data, Name, Address etc from a report (the report is based on certain criteria) and mail merge it into word. I am sure this has been asked bofore but i havn't found the answer on here

Rural Guy Thanks works great now

I want to ba able to search for only part of the field in a query. I want to run a reort from a query where the user only needs to enter part of the information from a product list ie the items listed may be as lisetd as make model in the same field. the user won't be able to get to the query to...

I am running a report based on a single table. The table relates to payments made both in and out. It includes things such as Total Sale, Cash, Card etc as well as till total carried forward (The report is based on a single week and so the user inputs last weeks closing balance, I am sure it...

yes it is the paymend id, the rest of the table are, Date,Amount,Reason,TillTotal,Up/Down,PettyCahType. The last one there is a look up Combo Box to a seperate table with only 2 cols and 4 records, this works fine.

When using DLookup IE =DLookup("[TillTotal]","Petty Cash" can i get it to look at the latest record and not the first by the date in the table basically it works fine if you do it once a day but if there are 2 entries for the same day it always recalls the first?

perhaps Dsum would be better Could I use DSum instead? I want to collect the total cash taken today from my Payments Table and display it in the cashing up form, based on a single table. I do have a query to total the cash based on date, but if I try to add this doesn't seem to work.

I know there are lots of questions relating to this function but I ahve searched and cannot find an answer. Can I add a Dlookup to a field that calculates a sum of the fields based on todays date? I am not very good a coding so any help welcome. I guess I am asking if Dlookup can be combined...

Is it possible to create a feild that will look a field in a table related to the date recorded in that table? I want a form which will show'Date' 'cash in' (which I get from a query, also date dependant ie field one is payment date, with a criteria of enter todays date and field 2 is sum of...

Thank for the quick response it worked great

I have a report based on a single table, one column is for the date. I want to be able to open the report based on date. If I add a criteria which asked for the date the report opens with all the data for that date, I tried to add an end date but when I run the query no data is returned. I used...

They are seperate I am using the standard order entry template that comes with access. I have modified the payments table, adding fields for Cash card etc. The Total sale is worked out in a query (also part of the template) to avoid staff entering the incorrect info (believe me they would) I...

Hi I have adapted the basic order enrty mdb, I have created an invoice to go with this without to many problems. I now want to create a report that shows sales figures for the day and or week. Not to difficult I agree but, and heres the bit that stumped me, the 'Total Sale' figure is calculated...