Search results

Please help me.... I have a field in a table called CostRed. I also have a date field linked to each record. The CostRed field is a numeric field and I would like to display the sum of all these fields within certain dates on a report. I have tried 2 potential solutions so far, firstly...

I have a report which I would like to generate with different fields depending on the data entered into those fields. Let me explain further.... I have 3 fields called saving, costred, and costavoid. For each record there may be data in only one of the fields. I would like my report to show...

I looking for some info on whether what I want to do is possible or not? I am looking to put together a general search mechanism in my database. What I want to happen is that when the user clicks a command button a text box appears. The user then enters a text string. The resulting query...

I've tried that and yes, it works in terms of displaying only the months and years. However I would like the users to enter the data in MM/YY format as well. If I do this with format set to MM/YY then if I enter in 09/01 (Sept 01) it stores 09/01/01 (9th Jan 01). What I really want it to...

I would like to enter and display dates in the MM/YY format. ie 05/01 means May 2001. I have tried setting the format and input mask settings to various things but none of them have been successful. When I enter the date 05/01 it returns 05/01/01. My way round it at the minute is to store the...