Search results

DAte Thanks for the reply. Actually - I have tried the following: nuDate: Format([Month]," yyyy mm") which allows me to order the data. Is the correct way to use the Format() function? Thanks! dj_T

Order by month Hello all, I am working on a query where there is one field that contains month information. The data has been stored in this fashion: 01/01/2000 etc... How might I sort this information in a normal monthly calendar style so that I might use the information properly (and...

ok! ah! ok! I'll do the calculations in queries and reports. Thanks for the help everyone. dj_T

best practice Thanks again, But what I would like to do is have this value placed in a normal field (text box) so that the user doesnt have to key it in. I would like the date to be automatically stored... Or! Should I not store this value this way? Instead calculate the new date "on the...

into a field automatically? Thank you for your reply. I used the following: =DateAdd("m",[fdlMonth],[fldDate1]) which adds the number of months in fldMonth onto the date in fldDate1. What I was wondering how might I automatically put this resulting value directly into a field on the form...

Dear All, I have two date fields and a "number of months" field. For example: Date1: 01/01/2004 Months: 6 Date2: 01/07/2004 (date1 x 6 months) What I would like to do is have a calculated text box that will show the user what date2 should be. Many thanks! dj_T

Hello all, Concerning the issue of a combo box. I have a table and one of the fields is populated by the user choosing from a combo list. When I make a report, the combo box appears as an actual combo box on the report (only the design stage.) The result is the data stored in that field is...

Dear all, I have some date data that I need to manipulate and change. Date information has been entered as: 01/01/2004 50 05/01/2004 50 17/01/2004 50 12/02/2004 100 22/02/2004 100 17/03/2004 100 etc... When I run a cross-tab query and group on the date, it treats individual dates...

Hello all, I would like to produce a variance field on my report. Basically this field should show the difference between two numbers - sometimes the number will be + (plus) or - (minus). I'm wondering how to go about this? For example: Jan number: 10 Feb number: 5 Variance = -5 or Jan...

Val & CDbl Hello, thanks for the reply! By the way - whats the difference between using: Order By Val(YourCodeFld); or Order By CDbl(YourCodeFld); I am also thinking of what happens when the field (result) contains both numbers and text. Is this a big problem? Thanks! dj_T

Hello, I wonder if there is a way around how queries are ordered. For example, if I have a series of numbers such as: 1 5 10 15 20 25 30 If I use ascending order, Access will order them as: 1 10 15 20 25 30 5 How do I get queries to be ordered as: 1 5 10 15 20 25 30 Many thanks! dj_T

Hello all, I would like to "bulk" update my records - but don't know how to do this at all. I have a two tables: one is a car table and the other is a jobs table. Each time a job gets done to a car, the users add the job to the job table. The relationship is one to many (each car can have...

Hello all, I would like to filter my form by allowing the user to click on: a drop-down menu or a selection group For example, if the underlying table was cars for example, i would like the user to be able to choose cars by colour. If it was a pull-down menu, the pull-down would be based...

Can't work Hello again, Now this is probably my lack of experience - BUT! I can't get it to work :( This is what I did: Created a blank form. Added a button (then canceled the wizard) Used "Build Event" to enter VBA editor. Inside VBA, I went to the Click Proceedure and pasted your code...

thanks cheers mate! & good luck. dj_T

Hello, I would like to place filter buttons directly on my form. The wizard allows for apply/edit form filterbuttons. But what I really need are buttons for: apply filter by selection and remove filter How would I do this? thanks! dj_T

Thanks for the reply. I understand what you mean, that makes sense. The problem is that I have no idea how to begin writing such code or how it works. It would be really great if you could help me with this - but it seems like a difficult (and interesting!) thing to explain :( Thanks again...

Example Thanks for the replies. It may well be that the best way to handle this data is to normalise the spreadsheet data the old fashioned way... However, here is an example of what I am talking about (see attached file). There is a tremendous amount of records! So if there was an automated...

Import advice and help! Hello, I have a strange difficult problem I would really appreciate help with! I have to import some data from a excel spreadsheet. The data is basically a list of shops with some information about work that has been done to them. The problem is the format: The...

Hello, I have a question concerning counting on a report. I have one field that contains colours, for example: fldCOLOUR Blue Blue Red Orange Blue Red What I would like to do is count each type of colour, for example: The number of Blue in fldCOLOUR is 3 The number of Red in fldCOLOUR is 2...