Search results

Thanks Gasman I looked at this and the look ups refer to another table so I think I would have to delete the table to remove everything in the lookup tab. That means I would lose all the data. I've been dicking about with this for a while now and I think the most straightforward method would be...

I know it's been a while but I've finally had a chance to revisit my db. I'm having trouble deciding whether to start from scratch, which means having to find out how to import the data from one db to another, or to rehash the current db to rectify the faults. I have discovered (thanks to you...

I can't argue with that. I've worked with software engineers who constantly use temporary workarounds which tend to become permanent fixes which breed constant updates in the form of patches which is a pseudonym for workarounds :) I have tried using Access 2019 Bible as my guide. I don't really...

Thanks for your comments/advice CJ. You're right, I do have more of an Excel head. This is my first venture into databases so I havven't developed a dbase head yet. It's quite a back-end type of dbase at the moment but as I'm the only one who uses it, it doesn't matter too much. I read the list...

Thanks for your observations. There are some interesting points here. The surveyor first and last names is a good one. There is absolutely nothing to stop a user from selecting a first name of one surveyor and a last name from another. Perhaps that needs a rethink. My original thinking was that...

Exactly right. One field, manually input values which can be any number.

I don't know if this helps to clarify my descriptions but here's a screenshot of the survey table and another short description of what values come from where: The company field is a drop down which references a Company table. The Site Name and Site Number are also drop downs which reference a...

Thanks Doc. Perhaps my explanation wasn't very clear. My table has a single price field which can contain any value. In my case, the values would be x, y or z. That is to say that each job would have its own price but several jobs would have the same price. The price for Job A might be x, Job B...

That's kind of difficult without breaching NDAs. As for SQL, I haven't really tried any. The process I have used is to Create > Query Design then filling in the table at the bottom with data from the table shown in the upper window. Apologies for the layman's description but I can't remember all...

OK, thanks Bastanu. So you're saying create a Price1 query, a Price2 query etc. I thought that would be the simplest approach. The final invoice can then take the data required from each separate query in the form of a report.

Hi Gasman Thanks for your response. Maybe I should have used a more algebraic method of description. I have a field called Price which contains £xxx, £yyy, £zzz according to the job that was completed. The way I am trying to create the automated invoice is to use a query which filters which...

Hi everyone Once again I find myself stuck with what is probably a very easy problem for you guys. I have a table of jobs that I have done. These jobs are done for various other companies. Each job is done for a particular price which is fixed, so I have Price1, Price2 and Price3 (for...

Thanks all for your replies. I may have misrepresented slightly what is going on here. The queries are multitable queries so the query sort of establishes a connection between the tables. The reports and forms are then based on the queries which is what I have done in any case in my own db...

Hi everyone I have been looking at an online course. It looks pretty good and I'm learning a lot from it and hopefully I will be able to create the database that I want that does all the things that I want it to so in that sense it's great. There's a demo database all ready to use with tables...

Thanks a lot Pat. That's good advice. I should have thought of it really. I know enough to understand that everything revolves around tables and their relationships :rolleyes:. Sometimes I can be a bit thick :(.

Thanks arnelgp. I've messed about with summing and grouping quite a bit and couldn't figure it out :(. I'll have another play with it and see what happens.

Thanks for the tip Pat. The date number is just a reference number which gives me the company and date if the invoice is queried so it's just a text reference rather than database related. I invoice customers on the last day of the month and only ever once. If it came to it I guess I would have...

Wow! That was quick! I've just tried it and it works a treat. Thanks very much. Just so that you don't think I didn't try anything like that, I did. I tried the format function but I used it with square brackets which I think might be more VBA syntax but I'm not sure. Anyway, thanks again.

Hi everyone I haven't been doing databases for very long so I'm sure my question will easily be solved. I am trying to create a report in order to invoice customers. The reference that I have been using has been the first four letters of the company's name followed by the 8 digits of the date. I...

Hi My name is Greg and I am pretty new to databases in general. I created my first (and only) database a couple of years ago for my business just to keep track of the work I do and for whom I do it mainly for invoicing purposes. My username on here is Celev Gadol. It is hebrew for Big Dog...